I have three queries. One that contains ALL items that have been received (qryLastRCTDate), one that has all items that have been shipped (qryLastShip), and one that contains the unmatched records (qryNoShip) i.e. the ones that have been received but never shipped.
Ultimately, I would like to combine both the items that have shipped AND the items that have never shipped to do an inventory analysis. At the moment, I have to analyze each seperately.
If anyone can tell me the best way to do this, I would be very grateful.
Thanks,
Steph
Ultimately, I would like to combine both the items that have shipped AND the items that have never shipped to do an inventory analysis. At the moment, I have to analyze each seperately.
If anyone can tell me the best way to do this, I would be very grateful.
Thanks,
Steph