I'm running into an issue with a union query - it is not properly gathering data from the table.
Database is relatively simple - I enter numeric values in various fields:
Example: Field [Front damage] - gets a numeric value of 1 every time a damage is found.
There is a simple query which shows the sum of the values entered into each field per month. I compare the sum monthly with another table through a union query... this is where the problem occurs. For example: June 2011 in the union query - shows a sum of 16 - however the simple query shows a sum of 17 for the same month.
The issue seems to be with double entries on the same day. What i mean by that is - On June 16 (ID 2468) there are entries in two fields - Field A has a numeric value of 1 and Field B has a numeric value of 1. Seems like the union query is only picking up one of the values. How can I get the query to pick up both values?
Any help is appreciated!
Database example attached.