i have a microsoft access database-
if you open it up and enter a serial number -hit enter- and do another serial number and hit enter - then click the add record button- you will see the serial numbers are sent into table-
problem: how to have other fields entered into table?
I may send 30 to 40 serial numbers in at one time- but the other fields-( Date, Run, Chk1, Chk2, Chk3, Chk4 and CVSKey) are only 1 time- but have to match up with serial numbers- each of serial numbers needs all fields filled in)
also if you look at qry1- you will CVSKey is based on which checkbox is checked
can this be done in next 24 hours