Hi and sorry if I am asking the wrong question here. I'm sort of flailing around. I used Access quite a bit a looooong time ago, but now I seem have forgotten everything I've learned. Anyway here is my mission.
I have a set of data that I get from a customer which shows the locations and the qty of the widget they tested and the qty that failed. This data comes once a month for the previous month. I also have a set of data with all the details on each widget that failed and was tested by a field technician, which is provided as the testing is completed. What I want to do is make sure that the total number of the tested units is equal to the total number reported as failed by the customer.
So I have two tables, as I described above and I am trying to make a query that will just show me line by line the qty tested and the qty reported by the customer.
The customer report table has the location, month being reported, model, input qty, and qty failed.
The details table has each individual widget and all it's failure and test information, among those are the date failed, location, serial number, model, etc.
Can someone show me how to do a simple query to accomplish my task?
And this is only the beginning because there are lots of other things I need to calculate after that.