Summing multiple tables

[Guest]

I am trying to use a query to sum up multiple tables. When run, it should
have like 14 fields with each having a sum total for a table. I have tried
doing this up to 3 tables (took a long while), but it didn't work for 4
tables; I just get a blank observation in the query view. So my questions are
if there is a way to do this for 14 tables and if this will take up a lot of
memory?

Thanks,
Henry

 

[Pat Hartman]

Since each of these tables is independent of the others, you should be using
14 queries. What is the point of doing the summation in a single query?
If you are doing this for a report or a form, you can use a DSum() as the
expression in each control. DSum() is pretty inefficient but should work
fine in this case.

=DSum("fld1", "tbl1")
=DSum("fld1", "tbl2")
......