Identify missing parts

  • Thread starter Thread starter Steve B
  • Start date Start date
S

Steve B

I import data into a table daily with a list of parts we
are receiving that day. Then as the parts are unpacked and
sorted we scan the barcode into a separate table that
includes the part number. I would like to compare the two
tables to ensure that all the parts were received. Both
tables have the part # field and after all the parts have
been unpacked and sorted the new table should be equal to
the original table. There may also be multiple instances
of the same part number which may create a problem. So
there may be ten separate scans with the same part number.
At the end of the day there should be about 500 scanned
part numbers and 500 parts listed on the packing slip. How
can I identify if all were received with a query?. Anyone
help with this. Thanks ahead of time.


Thanks
Steve B
 
it would help if you had posted the structure of the tables you are using
have you also considered the other possibility? that you get items not
listed in the packing list

HS
 
Back
Top