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

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

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.
 
Back
Top