Totals in Tables or Queries - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Totals in Tables or Queries

Gary Smith

5 years ago

Hi all,
I have a Quoting table with quoting detail table.
I would to total each line item, then mark it all up 10%, then show the grand total, then round that total up to the nearest 10.
Is it best to subtotal, mark up, retotal then round up each record in the quote detail table? Or should i make a query to do the total calculations at the end of each main quote id?
Then how do i get that final rounded total figure onto my report?
Many thanks
Gary

Scott Axton @Reply

5 years ago

The truth is there isn't a hard, fast rule on which way you have to do that.
Many times you can do the calculations with in one line item.  Other times, the calculation becomes too complex and you need to use  a second query to manipulate the results of the first query.

I usually only round once.  Rounding multiple times, in my opinion introduces "rounding errors".  You can always format the numbers differently than what is being used.

Check out Calculated Fields for and example of using the totaling.

	Richard Rost @Reply 5 years ago
Watch Invoicing and Form Footer Totals. I also cover designing an invoicing & quotation system in Access Expert 8.

	Gary Smith OP @Reply 5 years ago
Thanks Guys

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View