add records to table

[vaa571]

Hi, I have a table where i am storing the battery pack serial number and
board serial number inside this pack. after completion i have to add the lot#
to all records (more than 1000 packs are in the table). Is there an easy way
to do this task? also there will be more than one lot#, for example, packs
serial number 001 to 100 will be lot# 123456 and 101 to 578 will lot#56789
and so on. My table does have Lot# field Thanks.

 

[ghetto_banjo]

If you have a table with the serial number and lot number, you could
link that table to your first one by serial number and then do an
update query to update lot#s in the first table.

 

[vaa571]

Unfortunately I don't have a second table.I am intentionally leaving the Lot#
field on my table empty because it will slow down the assembly line if they
have to enter a five digit lot number when they are scanning in the “Pack
Serial Number†& the “Board Serial Number†into that table. I am rather enter
the lot number at the end of that lot, so it will save as a lot time I am
talking about over a thousand records per lot. I created an update query to
enter the lot#, it works if I only have one lot to update. Let’s say that I
have 2000 records in a table and the first thousand is lot# 12345 and the
remaining thousand should be lot# 67891. I ran the query it ask for input
starting pack and end pack serial number but when I am trying to run it to
update the remaining thousand packs it update all 2000 records. How can I
make this works and not loose the information already updated previously?
This table will continue to grow and I really need to keep track of the lot#
for each lot built and shipped.
Here is a copy of my query:

UPDATE Main AS Data SET [Lot Number] = [Enter Lot Number]
WHERE PackSerialNumber Between [Enter Starting Pack Serial Number] And
[Enter Ending Pack Serial Number];

Thanks again