Need help to make a Sum table

V

Van T. Dinh

I think your Table Structure is not properly designed.
The 3 Tables TableJanuary, TableFebruary, TableMarch
should be ONE Table with a (Date?) Field to specify which
Date/Month the figures come from.

Also, I am not sure what you meant by "Ajuster" (ID for
adjuster like Bob & Annie???) but if the Ajuster
identifies the Name, then the Name shouldn't even be in
the "Errors Table".

Only you know exactly what the Table Structure you need
for your database but I suggest you should look at the
Relational Database Design Principles and see if youe
existing Structure is correct.

In the mean time, you can try a UNION Query to combine the
3 Tables into 1 dataset and then use the UNION Query as
the Source for your Totals Query. If you are confident
with Access SQL, you can try to combine these 2 Queries /
SQL Strings into one Query / SQL String.

HTH
Van T. Dinh
MVP (Access)
 

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