<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="Street"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="address"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceType"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceName"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Times New Roman";
color:black;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>You will need the square brackets from my
experience. [item cost]<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
itapps-bounces@edulists.com.au [mailto:itapps-bounces@edulists.com.au] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Mark Scott<br>
<b><span style='font-weight:bold'>Sent:</span></b> Monday, 26 February 2007
1:16 PM<br>
<b><span style='font-weight:bold'>To:</span></b> Year 12 IT Applications
Teachers' Mailing List<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [Year 12 IT Apps]
Access Help (OT)</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'>create a report that includes the item
cost<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'>put in a page footer (design view) and
insert a text box<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'>right mouse button click go to properties
click on Data <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'>type in =sum(item cost) into the control
source section<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'>Mark Scott<o:p></o:p></span></font></p>
<p class=MsoNormal><st1:place w:st="on"><st1:PlaceName w:st="on"><font size=3
color=black face="Times New Roman"><span style='font-size:12.0pt;color:black'>Luther</span></font></st1:PlaceName><font
color=black><span style='color:black'> <st1:PlaceName w:st="on">College</st1:PlaceName></span></font></st1:place><font
color=black><span style='color:black'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> itapps-bounces@edulists.com.au
[mailto:itapps-bounces@edulists.com.au] <b><span style='font-weight:bold'>On
Behalf Of </span></b>WEIR Andrew<br>
<b><span style='font-weight:bold'>Sent:</span></b> Monday, 26 February 2007
12:21 PM<br>
<b><span style='font-weight:bold'>To:</span></b> <st1:PersonName w:st="on">Year
12 IT Applications Teachers' Mailing List</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> [Year 12 IT Apps] Access
Help (OT)</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'> Dear All </span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>I am looking for the simplest way of
creating a total for an access database</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>I have a field in my DB called item cost</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>what I would like is that at the end of a
report/query it will add together all of the item cost values to give me one
final total cost value</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>i.e.</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><br>
</span></font><font size=2 color=blue face=Arial><span style='font-size:10.0pt;
font-family:Arial;color:blue'>item 1 cost 20</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>item 2 cost 30</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>total is 50</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>I believe it has to do with queries and
reports but have not yet found a solution</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>Andrew<!-- Converted from text/plain format -->
<o:p></o:p></span></font></p>
<p style='margin-bottom:12.0pt'><font size=2 color=blue face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:blue'>Andrew Weir<br>
<br>
VK3HFT<br>
<br>
Information Technology Coordinator<br>
Intranet Manager<br>
<st1:place w:st="on"><st1:PlaceName w:st="on">Thomas</st1:PlaceName> <st1:PlaceName
w:st="on">Carr</st1:PlaceName> <st1:PlaceType w:st="on">College</st1:PlaceType></st1:place><br>
<br>
<st1:Street w:st="on"><st1:address w:st="on">35 Thomas Carr Drive</st1:address></st1:Street><br>
<br>
Tarneit<br>
<br>
3024<br>
<br>
Phone 97484 466<br>
<br>
Fax 9748 4388<br>
<br>
Disclaimer: This e-mail and any attachments may be confidential. You must not
disclose or use the information in this e-mail if you are not the intended
recipient. If you have received this e-mail in error, please notify <st1:place
w:st="on"><st1:PlaceName w:st="on">Thomas</st1:PlaceName> <st1:PlaceName w:st="on">Carr</st1:PlaceName>
<st1:PlaceType w:st="on">College</st1:PlaceType></st1:place> on 03 9748 4466
immediately and delete the e-mail and all copies. <st1:place w:st="on"><st1:PlaceName
w:st="on">Thomas</st1:PlaceName> <st1:PlaceName w:st="on">Carr</st1:PlaceName>
<st1:PlaceType w:st="on">College</st1:PlaceType></st1:place> does not
guarantee that this e-mail is virus or error free. The attached files are
provided and may only be used on the basis that the user assumes all
responsibility for any loss, damage or consequence resulting directly or
indirectly from the use of the attached files, whether caused by the negligence
of the sender or not. Any views expressed in this e-mail are the views of the
individual sending the message, and do not necessarily reflect the views held
by <st1:place w:st="on"><st1:PlaceName w:st="on">Thomas</st1:PlaceName> <st1:PlaceName
w:st="on">Carr</st1:PlaceName> <st1:PlaceType w:st="on">College</st1:PlaceType></st1:place>.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>_______________________________________________ <br>
<a href="http://www.edulists.com.au/" title="http://www.edulists.com.au/">http://www.edulists.com.au
</a>- FAQ, resources, subscribe, unsubscribe <br>
Year 7 - 10 IT Mailing List kindly supported by <br>
<a href="http://www.vcaa.vic.edu.au/" title="http://www.vcaa.vic.edu.au/">http://www.vcaa.vic.edu.au
</a>- Victorian Curriculum and Assessment Authority and <br>
<a href="http://www.vitta.org.au/" title="http://www.vitta.org.au/">http://www.vitta.org.au
</a>- VITTA Victorian Information Technology Teachers Association Inc <o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>_______________________________________________ <br>
<a href="http://www.edulists.com.au">http://www.edulists.com.au </a>- FAQ,
resources, subscribe, unsubscribe <br>
IT Applications Mailing List kindly supported by <br>
<a href="http://www.vcaa.vic.edu.au">http://www.vcaa.vic.edu.au </a>- Victorian
Curriculum and Assessment Authority and <br>
<a href="http://www.vitta.org.au">http://www.vitta.org.au </a>- VITTA Victorian
Information Technology Teachers Association Inc<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>_______________________________________________ <br>
<a href="http://www.edulists.com.au">http://www.edulists.com.au </a>- FAQ,
resources, subscribe, unsubscribe <br>
IT Applications Mailing List kindly supported by <br>
<a href="http://www.vcaa.vic.edu.au">http://www.vcaa.vic.edu.au </a>- Victorian
Curriculum and Assessment Authority and <br>
<a href="http://www.vitta.org.au">http://www.vitta.org.au </a>- VITTA Victorian
Information Technology Teachers Association Inc<o:p></o:p></span></font></p>
</div>
</body>
<!--[object_id=#padua.melb.catholic.edu.au#]--><P><STRONG><FONT face=Arial size=2>E-MAIL DISCLAIMER</FONT></STRONG></P>
<P><FONT face=Arial size=2>This e-mail and any files transmitted with it contain confidential information intended for the use of the individual or entity named above. If you are not the intended recipient of this e-mail you are hereby notified that you must not disseminate, copy or take action in reliance upon it. If you have received this message in error, please notify the sender immediately by return e-mail or telephone Reception at Padua College on (03) 5976 0100.</FONT> </P></html>