Query Totals

[Guest]

I’m trying to create a query that will calculate totals so that I can run
reports later using the totals Form the query.

The name of the table is: ChkDatabase
The field names are:
[BeginningChk] and [EndingChk]

What I’m trying to do is get the query to show an actual count with is
calculated by
Subtracting the endchk number from the beginningchk number.

In the form I created I am able to get this total by using this formula:
=[EndingChk]-[BeginningChk]

However the total displayed in the form doesn’t show in the table database.

I not sure what to do… any help would be greatly appreciated.
Thank you in advance.

 

[[MVP] S.Clark]

If you had an Orders and Orders detail table, then you could store the Order
Total in the Orders table. But, you would have to update it every time the
details changed. This is the problem with storing totals... knowing when
they are really correct / final / etc.

I don't know your table structures, but you need to consider the
ramifications of where the total field should be stored, and how and when it
will be updated.

 

[Guest]

Thank you.

Outside of storing my totals in tables is there a way to still get totals in
my reports?
or is the Order Table the only way you can see that happening?

As for table structure. The totals I guess would be a running total so I
see where the Order table would be a problem. I would like to pull totals by
date, month, and even year to date. This may be to much for what I have
setup. i again thank you for your time and help.

 

[[MVP] S.Clark]

Totals and Running totals are simply in reports. In the desired footer put:

=Sum([Fieldname])

Set the Running Sum property to True when needed.

 

[Guest]

Thank you so much, you have been a great help.
Have a great day.