<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" 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"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16414" name=GENERATOR><!--[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 name="Street"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="address"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="place"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="PlaceType"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="PlaceName"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="PersonName"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><!--[if !mso]>
<STYLE>st1\:* {
BEHAVIOR: url(#default#ieooui)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
font-family: Tahoma;
}
@page Section1 {size: 612.0pt 792.0pt; margin: 72.0pt 90.0pt 72.0pt 90.0pt; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: blue; TEXT-DECORATION: underline
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; FONT-FAMILY: "Times New Roman"; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
SPAN.EmailStyle18 {
FONT-WEIGHT: normal; COLOR: black; FONT-STYLE: normal; FONT-FAMILY: "Times New Roman"; TEXT-DECORATION: none; mso-style-type: personal
}
SPAN.EmailStyle19 {
COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal-reply
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=blue link=blue>
<DIV dir=ltr align=left><SPAN class=815264902-26022007><FONT face=Arial
color=#0000ff size=2>Thank you</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=815264902-26022007><FONT face=Arial
color=#0000ff size=2>I was using the right formula just in the wrong
location</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=815264902-26022007><FONT face=Arial
color=#0000ff size=2>need to remember to put it in the report
footer.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=815264902-26022007><FONT face=Arial
color=#0000ff size=2>regards</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=815264902-26022007><FONT face=Arial
color=#0000ff size=2>Andrew</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> itapps-bounces@edulists.com.au
[mailto:itapps-bounces@edulists.com.au] <B>On Behalf Of </B>David
Howard<BR><B>Sent:</B> Monday, 26 February 2007 1:28 PM<BR><B>To:</B> Year 12 IT
Applications Teachers' Mailing List<BR><B>Subject:</B> RE: [Year 12 IT Apps]
Access Help (OT)<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">You will need the
square brackets from my experience. [item cost]<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<DIV>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><FONT
face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">
<HR tabIndex=-1 align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P class=MsoNormal><B><FONT face=Tahoma size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; 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 face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=black size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: black">create a report that includes the item
cost<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=black size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: black"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=black size=3><SPAN
style="FONT-SIZE: 12pt; 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 face="Times New Roman" color=black size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: black"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=black size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: black">right mouse button click go to properties
click on Data <o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=black size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: black">type in =sum(item cost) into the control
source section<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=black size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: black"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=black size=3><SPAN
style="FONT-SIZE: 12pt; 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
face="Times New Roman" color=black size=3><SPAN
style="FONT-SIZE: 12pt; 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 face="Times New Roman" color=black size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: black"><o:p> </o:p></SPAN></FONT></P>
<DIV>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><FONT
face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">
<HR tabIndex=-1 align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P class=MsoNormal><B><FONT face=Tahoma size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; 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 face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<DIV>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial"> Dear
All </SPAN></FONT><o:p></o:p></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">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 face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">I have a field in my DB
called item cost</SPAN></FONT><o:p></o:p></P>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">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 face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">i.e.</SPAN></FONT><o:p></o:p></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><BR></SPAN></FONT><FONT face=Arial color=blue
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">item 1
cost 20</SPAN></FONT><o:p></o:p></P>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">item 2 cost
30</SPAN></FONT><o:p></o:p></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">total is
50</SPAN></FONT><o:p></o:p></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">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 face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">Andrew<!-- Converted from text/plain format -->
<o:p></o:p></SPAN></FONT></P>
<P style="MARGIN-BOTTOM: 12pt"><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">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 face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">_______________________________________________ <BR><A
title=http://www.edulists.com.au/
href="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 title=http://www.vcaa.vic.edu.au/
href="http://www.vcaa.vic.edu.au/">http://www.vcaa.vic.edu.au </A>- Victorian
Curriculum and Assessment Authority and <BR><A title=http://www.vitta.org.au/
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>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">_______________________________________________ <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 face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">_______________________________________________ <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>_______________________________________________
<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 <!--[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></BODY></HTML>