How do I total a value of a field from several tables

[Guest]

I have several tables linked to a main table using a unique reference. Each
table has a credit and debit field. I have created a query using the main
table joined to the other tables (using the unique reference) in order to
calculate the total credit and debit balances. Unfortunately, if one of the
tables does not have any data entered either in the credit or debit field,
the query does not work. Any help would be appreciated.

 

[Allen Browne]

Use outer joins in your query.

Details in:
The Query Lost My Records! (Nulls)
at:
http://allenbrowne.com/casu-02.html