Let me start by saying I'm not a VB person, but I think the only way for me to do this is through code module.
I have one report that is combining the results from two queries.
the first query is the result of a user scanning inventory into the database. It is returning information such as the part number, description, UPC and a sum field for Qty. So if he scans 5 pieces the report returns one line of 5.
the second query is showing any inventory in a specified location (location x) that matches the scanned results.
So my user scans 5 pieces of part A and my queries find 7 pieces of part A in location x.
Currently my report will return all 7 records when I only need the oldest 5 that matches the qty of what was scanned.
Is there a way to set the number of return records based on the recordset of another query?
any suggestions will be greatly appreciated.