How do I create a form totalling several values from several tabl.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several tables containing a currency field. I want to total the sum
from all the currency fields in the tables into one calculated field. I have
prepared a query showing each table with its corresponding currency field.
When running the query it remains blank even though I know some of the fields
in some of the tables contain a value. Any help would be appreciated
 
Wayne

You didn't mention how you've combined those multiple tables (?joined on ?),
nor provided the SQL statement.

This is only a guess ... your query uses "equi-joins" (only show me rows
when ALL tables have a corresponding value). If ANY of the tables might not
have the common identifier, use LEFT or RIGHT joins (i.e., "directional"),
which will show all of one table's records and ANY matching records in other
tables.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top