On Tue, 25 Nov 2008 02:46:01 -0800, Elaine
<Elaine[ at ]discussions.microsoft.com> wrote:
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
[Quoted Text] >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?
|