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

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
 
J

Jeff Boyce

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top