<!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="City"
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="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="place"
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;
}
@font-face {
font-family: Lucida Calligraphy;
}
@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.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"; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
SPAN.EmailStyle18 {
COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal
}
SPAN.EmailStyle19 {
COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal
}
SPAN.EmailStyle23 {
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=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<!-- Converted from text/plain format -->
<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></BODY></HTML>