Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Question for ACCESS version office 97!

Status
Not open for further replies.

matt1001

MIS
Nov 13, 1999
5
US
in a query is there any way to autosum numbers at the end of a query. for examble i want it to autosum a query on doctors hours which works with decimals. please help. if i didn't explain my self enuf just tell me and i will trie to explain better. thanks
 
Summing: you can use a separate summation query. If for some reason you must do this in the same query, you could then pull the summing query up with the original as a new query. BUT: this would give you your sum, but it would be listed in every record. <br>
It might be possible to slap a sum function together to get your total. BUT: This might lead to the same effect as above.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top