[Year 12 IT Apps] Access Help (OT)

[Bane, Janet A]

Hi Andrew
 
You can use the sum function - just type in =3Dsum([item cost])   or whateve=
r your field is called in square brackets.
 
Go to report, design view,and then in the Report footer section add in a lab=
el, then type the above formula in.
 
You can also do fun things like the count function which counts the number o=
f items in a field, just use =3Dcount instead of =3Dsum
 
hope this helps
 
Janet Bane
Patterson River SC

________________________________

From: itapps-bounces at edulists.com.au on behalf of WEIR Andrew
Sent: Mon 26-Feb-07 12:20 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: [Year 12 IT Apps] Access Help (OT)


 Dear All 
 
I am looking for the simplest way of creating a total for an access database
I have a field in my DB called item cost
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
 
i.e.

item 1 cost 20
item 2 cost 30
 
total is 50
 
I believe it has to do with queries and reports but have not yet found a sol=
ution
 
Andrew 

Andrew Weir

VK3HFT

Information Technology Coordinator
Intranet Manager
Thomas Carr College

35 Thomas Carr Drive

Tarneit

3024

Phone 97484 466

Fax 9748 4388

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 Thomas=
 Carr College on 03 9748 4466 immediately and delete the e-mail and all copi=
es. Thomas Carr College does not guarantee that this e-mail is virus or erro=
r free. The attached files are provided and may only be used on the basis th=
at the user assumes all responsibility for any loss, damage or consequence r=
esulting 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 nece=
ssarily reflect the views held by Thomas Carr College.



_______________________________________________ 
http://www.edulists.com.au <http://www.edulists.com.au/> - FAQ, resources, s=
ubscribe, unsubscribe 
Year 7 - 10 IT Mailing List kindly supported by 
http://www.vcaa.vic.edu.au <http://www.vcaa.vic.edu.au/> - Victorian Curricu=
lum and Assessment Authority and 
http://www.vitta.org.au <http://www.vitta.org.au/> - VITTA Victorian Informa=
tion Technology Teachers Association Inc 
_______________________________________________ 
http://www.edulists.com.au <http://www.edulists.com.au/> - FAQ, resources, s=
ubscribe, unsubscribe 
IT Applications Mailing List kindly supported by 
http://www.vcaa.vic.edu.au <http://www.vcaa.vic.edu.au/> - Victorian Curricu=
lum and Assessment Authority and 
http://www.vitta.org.au <http://www.vitta.org.au/> - VITTA Victorian Informa=
tion Technology Teachers Association Inc 

Important - This email and any attachments may be confidential. If received=
 in error, please contact us and delete all copies. Before opening or using=
 attachments check them for viruses and defects. Regardless of any loss, dam=
age or consequence, whether caused by the negligence of the sender or not, r=
esulting directly or indirectly from the use of any attached files our liabi=
lity is limited to resupplying any affected attachments. Any representations=
 or opinions expressed are those of the individual sender, and not necessari=
ly those of the Department of Education.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 7067 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20070226/bc077150/attachment.bin