[Year 12 IT Apps] Access Help (OT)

[WEIR Andrew]

Thank you
I was using the right formula just in the wrong location
need to remember to put it in the report footer.
regards
Andrew

________________________________

From: itapps-bounces at edulists.com.au
[mailto:itapps-bounces at edulists.com.au] On Behalf Of David Howard
Sent: Monday, 26 February 2007 1:28 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: RE: [Year 12 IT Apps] Access Help (OT)



You will need the square brackets from my experience. [item cost]

 

________________________________

From: itapps-bounces at edulists.com.au
[mailto:itapps-bounces at edulists.com.au] On Behalf Of Mark Scott
Sent: Monday, 26 February 2007 1:16 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: RE: [Year 12 IT Apps] Access Help (OT)

 

create a report that includes the item cost

 

put in a page footer (design view) and insert a text box

 

right mouse button click go to properties click on Data 

type in =sum(item cost) into the control source section

 

Mark Scott

Luther College

 

________________________________

From: itapps-bounces at edulists.com.au
[mailto:itapps-bounces at edulists.com.au] On Behalf Of WEIR Andrew
Sent: Monday, 26 February 2007 12:21 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
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 <http://www.edulists.com.au/> - FAQ,
resources, subscribe, unsubscribe 
Year 7 - 10 IT Mailing List kindly supported by 
http://www.vcaa.vic.edu.au <http://www.vcaa.vic.edu.au/> - Victorian
Curriculum and Assessment Authority and 
http://www.vitta.org.au <http://www.vitta.org.au/> - VITTA Victorian
Information Technology Teachers Association Inc 

_______________________________________________ 
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe 
IT Applications 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

_______________________________________________ 
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe 
IT Applications 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

_______________________________________________ 
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe 
IT Applications 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 

E-MAIL DISCLAIMER

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. 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20070226/32ababcb/attachment-0001.html