<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16414" name=GENERATOR>
<STYLE>font-face {
FONT-FAMILY: Tahoma
}
font-face {
FONT-FAMILY: Lucida Calligraphy
}
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.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; FONT-FAMILY: "Times New Roman"
}
SPAN.EmailStyle18 {
COLOR: navy; FONT-FAMILY: Arial
}
SPAN.EmailStyle19 {
COLOR: navy; FONT-FAMILY: Arial
}
SPAN.EmailStyle23 {
COLOR: navy; FONT-FAMILY: Arial
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US dir=ltr vLink=blue link=blue>
<DIV dir=ltr align=left><SPAN class=510143401-26022007><FONT face=Arial
color=#0000ff size=2>Dam</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=510143401-26022007><FONT face=Arial
color=#0000ff size=2>I hate it when things are that simple.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=510143401-26022007><FONT face=Arial
color=#0000ff size=2>it worked absolutely perfectly.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=510143401-26022007><FONT face=Arial
color=#0000ff size=2>thank you</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=510143401-26022007></SPAN> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> yr7-10it-bounces@edulists.com.au
[mailto:yr7-10it-bounces@edulists.com.au] <B>On Behalf Of </B>Judy
Zuccon<BR><B>Sent:</B> Monday, 26 February 2007 12:11 PM<BR><B>To:</B> Year 7 -
10 Information Technology Teachers' Mailing List<BR><B>Subject:</B> RE:
[Yr7-10it] Access help<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>Hi Andrew,</DIV>
<DIV>I hope this works....</DIV>
<DIV> </DIV>
<DIV>Create your report that includes the field [item cost].</DIV>
<DIV> </DIV>
<DIV>In Report Design View, drag down the report footer (it will not be
visible).</DIV>
<DIV>In the Report Footer, draw a text box (AB) and use this formula =sum([item
cost])</DIV>
<DIV> </DIV>
<DIV> If you need to multiple items (eg 10 x item 1 at cost 20, etc) this
can be done in a query first using the Expression Builder and then the total
calculated added as above.</DIV>
<DIV> </DIV>
<DIV>Judy Zuccon</DIV>
<DIV>Aquinas College</DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><FONT size=2>-----Original Message----- <BR><B>From:</B>
yr7-10it-bounces@edulists.com.au on behalf of WEIR Andrew
<BR><B>Sent:</B> Mon 26/02/2007 11:53 AM <BR><B>To:</B> Year 7 - 10
Information Technology Teachers' Mailing List <BR><B>Cc:</B>
<BR><B>Subject:</B> [Yr7-10it] Access help<BR><BR></FONT></DIV>
<DIV dir=ltr align=left><SPAN class=915065000-26022007><FONT face=Arial
color=#0000ff size=2>dear all</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=915065000-26022007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=915065000-26022007><FONT face=Arial
color=#0000ff size=2>I am looking for the simplest way of creating a total for
an access database</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=915065000-26022007><FONT face=Arial
color=#0000ff size=2>I have a field in my DB called item
cost</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=915065000-26022007><FONT face=Arial
color=#0000ff size=2>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</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=915065000-26022007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=915065000-26022007><FONT face=Arial
color=#0000ff size=2>i.e.</FONT></SPAN></DIV><SPAN class=915065000-26022007>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2></FONT><BR><FONT
face=Arial color=#0000ff size=2>item 1 cost 20</FONT></DIV>
<DIV dir=ltr align=left><SPAN class=915065000-26022007><FONT face=Arial
color=#0000ff size=2>item 2 cost 30</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=915065000-26022007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=915065000-26022007><FONT face=Arial
color=#0000ff size=2>total is 50</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=915065000-26022007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=915065000-26022007><FONT face=Arial
color=#0000ff size=2>I believe it has to do with queries and reports but have
not yet found a solution</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=915065000-26022007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=915065000-26022007><FONT face=Arial
color=#0000ff size=2>Andrew
<P><FONT size=2>Andrew Weir<BR><BR>VK3HFT<BR><BR>Information Technology
Coordinator<BR>Intranet Manager<BR>Thomas Carr College<BR><BR>35 Thomas Carr
Drive<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
Thomas Carr College on 03 9748 4466 immediately and delete the e-mail and all
copies. Thomas Carr College 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 Thomas Carr
College.<BR><BR></FONT></P></FONT></SPAN></SPAN></DIV>_______________________________________________
<BR><A 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
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</BLOCKQUOTE></BODY></HTML>