searching for a certain filed name from multiple tables

[funi.t]

hi
I have around twenty shipment tables for different days and one main store check table.In the shipment tables i have bill numbers that correspond with shipping id's and in the store table i only have bill numbers.

I would like to check if the bill number in the store table appears in all 20 tables.after doing that i want the corresponding shipping ID to appear in the store table.

is this possible?

[alansidman]

It appears that you have a normalization issue. Why do you have 20 tables with shipment information. To make this work easily, all the shipping data should be in one table.

Please read this on normalization.

http://www.deeptraining.com/litwin/d...aseDesign.aspx

[funi.t]

The reason why there are many tables is because a shipping master report is received every second day.

From all these shipping tables i also need to track down how long a certain shipping number has been in the the records.
for example:i received a shipping report on the 3rd,5th,7th and11th of november,for all this days sj41525285 only appears on the 5th,7th and 11th of november.I should be able to get the age of this shipping id which is 6 days.

please help

[funi.t]

can you recommend any books on Acess database designs.
thanks

[alansidman]

When I started, I used Virginia Anderson's book which was written for Access 2002. I am sure she has an updated version. Look on
Amazon. Also, look at this site.

http://www.accessmvp.com/strive4peace/

Look at Youtube videos, use Google a lot (its your friend) and lookup Allen Browne in Google.

[funi.t]

thank you for you help and patience