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?
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?