By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,846 Members | 1,406 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,846 IT Pros & Developers. It's quick & easy.

Update Query with serialized Field

P: n/a
Hello -

I am trying to execute an update query, updating 4 fields in one table.
Is there a way that I can enter the first value for each field, and
then serialize the first field for a given qty, while duplication the
other 4? I want to avoid having to enter every single record manually.


Serial Batch Part Tech
123 500 A1 ABC
124 500 A1 ABC
125 500 A1 ABC

Apr 19 '06 #1
Share this Question
Share on Google+
1 Reply

P: n/a
the way I usually handle this is to create an unbound form and then
write some code to loop from StartSerial to EndSerial and then just use
a recordset to fill the table.

for lngSerial = val(me.controls("StartingSerialNo")) to
next lngSerial

Apr 20 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.