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

Can you update a field in a Select query automatically?

P: n/a
I have a Select query which contains a field called AMWnum (long) which
represents a sequence # of sorts.
If I want to copy a row of information and paste it on the bottom, all is
OK.

I have another query which finds the max AMWnum in the table and then adds
1.

What I would like to do is automatically update the copied record's AMWnum
field with the value found in the MAX_AVMnum query.
following the copy operation.

Is this possible in one or two steps?

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.