Hello All,
I created a new small database for tracking Inspection of labels printed. I had some issues at first that were quickly resolved with input from the great folks on this forum.
I was putting in some real data today and found some errors (omissions really) in a query and the resulting report. I am using "Query1" (Sorry I should have deleted the other query before zipping the file.) I didn't realize there were omissions at first but after putting in 11 records I saw that some were missing on the report. Further looking into it LabelID's 3 and 12 are missing from the report.
If you run the report "Label Report All" (which uses "Query1") you get the report showing 9 records, if you look at "tblLabels" you see there are 11 records and the LabelID shows 1-10 & 12, LabelID 11 is missing (not sure why) for a total of 11 records.
Any idea why the report is matching the data in the tables, or the query?
(Edit) - After creating a new query without reject info (because the last entry had no rejects, I got all 11 records when I ran the query. This won't do for a report though because I want all records, those with and without rejects to show on the report.
Thanks
Dave
Label Inspection - New.zip