B
Ben
Hi all,
I would like to write a query, where I can create an auto number field.
That is if my query brings back 100 or 1M records, this field would contain
that value, ie, in the first record, the autonumber field would be 1, in
the second record, the autonumber field would be 2...etc all the way to the
last record, if it is 100 then the field value for the last record on this
autonumber would be 100.
Is there a way to do that? Thanks for sharing your thoughts.
Ben
I would like to write a query, where I can create an auto number field.
That is if my query brings back 100 or 1M records, this field would contain
that value, ie, in the first record, the autonumber field would be 1, in
the second record, the autonumber field would be 2...etc all the way to the
last record, if it is 100 then the field value for the last record on this
autonumber would be 100.
Is there a way to do that? Thanks for sharing your thoughts.
Ben