<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micro=
soft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" xm=
lns:st1=3D"urn:schemas-microsoft-com:office:smarttags" xmlns=3D"http://www.w=
3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Dus-ascii">
<meta name=3DGenerator content=3D"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=3D"urn:schemas-microsoft-com:office:smarttags" name=3D"Street"=
/>
<o:SmartTagType namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"address"/>
<o:SmartTagType namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"place"/>
<o:SmartTagType namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"PlaceName"/>
<o:SmartTagType namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"PlaceType"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Wingdings 2";
panose-1:5 2 1 2 1 5 7 7 7 7;}
@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";}
p.Z1, li.Z1, div.Z1
{margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:24.0pt;
margin-bottom:.0001pt;
text-align:center;
font-size:14.0pt;
font-family:"Wingdings 2";
font-weight:bold;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:595.3pt 841.9pt;
margin:72.5pt 89.85pt 72.0pt 89.85pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=3DEN-AU link=3Dblue vlink=3Dblue>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=3D=
'font-size:
10.0pt;font-family:Arial;color:navy'>Another method is to create a query wit=
h
the two items and right click on the next free field, select <b><span
style=3D'font-weight:bold'>zoom</span></b> and type the formula as per below=
:<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=3D=
'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=3D=
'font-size:
10.0pt;font-family:Arial;color:navy'>Total_Cost:[item1]*[item2]<o:p></o:p></=
span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=3D=
'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=3D=
'font-size:
10.0pt;font-family:Arial;color:navy'>Then use the query to write a report.<o=
:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=3D=
'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div>
<p class=3DMsoNormal><em><b><i><font size=3D5 color=3Dblue face=3D"Times New=
Roman"><span
style=3D'font-size:18.0pt;color:blue;font-weight:bold'>Ian Clare</span></fon=
t></i></b></em><font
color=3Dnavy><span style=3D'color:navy'><o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=3D=
'font-size:
10.0pt;font-family:Arial;color:navy'>Information Technology Teacher</span></=
font><font
color=3Dnavy><span style=3D'color:navy'><o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><st1:place w:st=3D"on"><st1:PlaceName w:st=3D"on"><stro=
ng><b><font
size=3D2 color=3Dnavy face=3DArial><span style=3D'font-size:10.0pt;font-fa=
mily:Arial;
color:navy'>Casterton</span></font></b></strong></st1:PlaceName><strong><b=
><font
size=3D2 color=3Dnavy face=3DArial><span style=3D'font-size:10.0pt;font-fam=
ily:Arial;
color:navy'> <st1:PlaceName w:st=3D"on">Secondary</st1:PlaceName> <st1:Plac=
eType
w:st=3D"on">College</st1:PlaceType></span></font></b></strong></st1:place><=
font
color=3Dnavy><span style=3D'color:navy'><o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=3D=
'font-size:
10.0pt;font-family:Arial;color:navy'>Ph 03 5581 1588 Fax 03 5581
1518</span></font><font color=3Dnavy><span style=3D'color:navy'><o:p></o:p><=
/span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=3D=
'font-size:
10.0pt;font-family:Arial;color:navy'><a
href=3D"BLOCKED::mailto:clare.ian.j@edumail.vic.gov.au"
title=3D"mailto:clare.ian.j@edumail.vic.gov.au">clare.ian.j@edumail.vic.gov.=
au</a></span></font><o:p></o:p></p>
</div>
</div>
<div>
<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font size=
=3D3
face=3D"Times New Roman"><span lang=3DEN-US style=3D'font-size:12.0pt'>
<hr size=3D2 width=3D"100%" align=3Dcenter tabindex=3D-1>
</span></font></div>
<p class=3DMsoNormal><b><font size=3D2 face=3DTahoma><span lang=3DEN-US
style=3D'font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span><=
/font></b><font
size=3D2 face=3DTahoma><span lang=3DEN-US style=3D'font-size:10.0pt;font-fam=
ily:Tahoma'>
WEIR Andrew [mailto:WEIR@thomascarr.vic.edu.au] <br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Monday, 26 February 200=
7
12:21 PM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> Year 12 IT Applications
Teachers' Mailing List<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> [Year 12 IT Apps] Ac=
cess
Help (OT)</span></font><span lang=3DEN-US><o:p></o:p></span></p>
</div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span style=3D'=
font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DArial><span style=3D=
'font-size:
10.0pt;font-family:Arial;color:blue'> Dear All </span></font><o:p>=
</o:p></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span style=3D'=
font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DArial><span style=3D=
'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=3DMsoNormal><font size=3D2 color=3Dblue face=3DArial><span style=3D=
'font-size:
10.0pt;font-family:Arial;color:blue'>I have a field in my DB called item cos=
t</span></font><o:p></o:p></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DArial><span style=3D=
'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=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span style=3D'=
font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DArial><span style=3D=
'font-size:
10.0pt;font-family:Arial;color:blue'>i.e.</span></font><o:p></o:p></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span style=3D'=
font-size:
12.0pt'><br>
</span></font><font size=3D2 color=3Dblue face=3DArial><span style=3D'font-s=
ize:10.0pt;
font-family:Arial;color:blue'>item 1 cost 20</span></font><o:p></o:p></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DArial><span style=3D=
'font-size:
10.0pt;font-family:Arial;color:blue'>item 2 cost 30</span></font><o:p></o:p>=
</p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span style=3D'=
font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DArial><span style=3D=
'font-size:
10.0pt;font-family:Arial;color:blue'>total is 50</span></font><o:p></o:p></p=
>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span style=3D'=
font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DArial><span style=3D=
'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=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span style=3D'=
font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DArial><span style=3D=
'font-size:
10.0pt;font-family:Arial;color:blue'>Andrew<!-- Converted from text/plain fo=
rmat -->
<o:p></o:p></span></font></p>
<p style=3D'margin-bottom:12.0pt'><font size=3D2 color=3Dblue face=3DArial><=
span
style=3D'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=3D"on"><st1:PlaceName w:st=3D"on">Thomas</st1:PlaceName> <st=
1:PlaceName
w:st=3D"on">Carr</st1:PlaceName> <st1:PlaceType w:st=3D"on">College</st1:Pl=
aceType></st1:place><br>
<br>
<st1:Street w:st=3D"on"><st1:address w:st=3D"on">35 Thomas Carr Drive</st1:a=
ddress></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 no=
t
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:pla=
ce
w:st=3D"on"><st1:PlaceName w:st=3D"on">Thomas</st1:PlaceName> <st1:PlaceName=
w:st=3D"on">Carr</st1:PlaceName>
<st1:PlaceType w:st=3D"on">College</st1:PlaceType></st1:place> on 03 9748 4=
466
immediately and delete the e-mail and all copies. <st1:place w:st=3D"on"><st=
1:PlaceName
w:st=3D"on">Thomas</st1:PlaceName> <st1:PlaceName w:st=3D"on">Carr</st1:Pla=
ceName>
<st1:PlaceType w:st=3D"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 neglige=
nce
of the sender or not. Any views expressed in this e-mail are the views of th=
e
individual sending the message, and do not necessarily reflect the views hel=
d
by <st1:place w:st=3D"on"><st1:PlaceName w:st=3D"on">Thomas</st1:PlaceName>=
<st1:PlaceName
w:st=3D"on">Carr</st1:PlaceName> <st1:PlaceType w:st=3D"on">College</st1:Pl=
aceType></st1:place>.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span style=3D'=
font-size:
12.0pt'>_______________________________________________ <br>
<a href=3D"http://www.edulists.com.au/" title=3D"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=3D"http://www.vcaa.vic.edu.au/" title=3D"http://www.vcaa.vic.edu.au/=
">http://www.vcaa.vic.edu.au
</a>- Victorian Curriculum and Assessment Authority and <br>
<a href=3D"http://www.vitta.org.au/" title=3D"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>
</div>
<p></p><p><b>Important - </b>This email and any attachments may be confident=
ial. If received in error, please contact us and delete all copies. Before o=
pening or using attachments check them for viruses and defects. Regardless o=
f any loss, damage or consequence, whether caused by the negligence of the s=
ender or not, resulting directly or indirectly from the use of any attached=
files our liability is limited to resupplying any affected attachments. Any=
representations or opinions expressed are those of the individual sender, a=
nd not necessarily those of the Department of Education.</p></body>
</html>