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



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.

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