Multiple totals and tables

[Elaine]

I have multiple tables with total fields, I need to add to a Main total field
in a form therefore calculating all the total fields into one field. I have
tried a query but that didnt work.

Any Ideas?

 

[Tom van Stiphout]

On Tue, 25 Nov 2008 02:46:01 -0800, Elaine

It seems you have a database design problem, because except for rare
cases Totals fields don't belong in the database.
Then reading between the lines you have multiple tables with similar
layout (I'm guessing a new table per year, or one per customer) that
you now want to sum up. That's another database design violation.

Can you describe your database, so we may suggest alternatives? After
that we can discuss summing data, which at that point should be easier
than it is now.

-Tom.
Microsoft Access MVP