I need to make a query for a report.
The query needs to look like this: SEE IMAGE 1
I have multiple tables that need to be included in this query. The table structure looks like this:
SEE IMAGE 2
SEE IMAGE 3
The query should seperate the items by month (ie. "1/*"), then it should look at the "GoodBad" field of all tables... add up the unchecked (0), then add the checked (-1) then divide the bad (unchecked/0) by the good (checked/-1) to get the error rate.