B
Barbara H
I have 3 tables that someone else created that all contain identical
information columns but for different years. I just need to create a query
that will search these 3 tables for a particular number that could appear in
any one of the tables in a column titled LotNumber. I cannot figure out how
to relate these identical tables since there isn't a one to many
relationship. They all have many lot numbers and all have the heading for
that column as LotNumber. The pupose for the search is to find the "File Box"
location of the lot number being searched.
CODE LOT NUMBER QTY PACKAGING FILE BOX
753322 4068HG7533 3 BTL-240 0001 0011589
191041 4150IG1910 3 BTL-300 0001 0012698
information columns but for different years. I just need to create a query
that will search these 3 tables for a particular number that could appear in
any one of the tables in a column titled LotNumber. I cannot figure out how
to relate these identical tables since there isn't a one to many
relationship. They all have many lot numbers and all have the heading for
that column as LotNumber. The pupose for the search is to find the "File Box"
location of the lot number being searched.
CODE LOT NUMBER QTY PACKAGING FILE BOX
753322 4068HG7533 3 BTL-240 0001 0011589
191041 4150IG1910 3 BTL-300 0001 0012698