Help

  • 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
 
-----Original Message-----
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


.
You could try something like this. First open a new
Click to expand...
query in design mode, add both tables to the query, make
and join the two tables part numbers by clicking and
dragging P/N on table one to table2. Then set the join
property to include all from table1 and only record from
table2 where they both match. Then add this code to the
field row of the query and it should show the part
numbers that do not have a match. Of course change the
names to match you tables

MissingPartNum: IIf([table2].[num1] Is Null,[table1].
[num1],"")

Good Luck,
Doug
 
Back
Top