[Yr7-10it] Access help

[WEIR Andrew]

Dam
I hate it when things are that simple.
it worked absolutely perfectly.
thank you
 

________________________________

From: yr7-10it-bounces at edulists.com.au
[mailto:yr7-10it-bounces at edulists.com.au] On Behalf Of Judy Zuccon
Sent: Monday, 26 February 2007 12:11 PM
To: Year 7 - 10 Information Technology Teachers' Mailing List
Subject: RE: [Yr7-10it] Access help


Hi Andrew,
I hope this works....
 
Create your report that includes the field [item cost].
 
In Report Design View, drag down the report footer (it will not be
visible).
In the Report Footer, draw a text box (AB) and use this formula
=sum([item cost])
 
 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.
 
Judy Zuccon
Aquinas College

	-----Original Message----- 
	From: yr7-10it-bounces at edulists.com.au on behalf of WEIR Andrew 
	Sent: Mon 26/02/2007 11:53 AM 
	To: Year 7 - 10 Information Technology Teachers' Mailing List 
	Cc: 
	Subject: [Yr7-10it] Access help
	
	
	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 solution
	 
	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 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.
	
	

	_______________________________________________ 
	http://www.edulists.com.au - FAQ, resources, subscribe,
unsubscribe 
	Year 7 - 10 IT Mailing List kindly supported by 
	http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment
Authority and 
	http://www.vitta.org.au - VITTA Victorian Information Technology
Teachers Association Inc

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/yr7-10it/attachments/20070226/d3b7b558/attachment.html