Hi,
append the data to a table with an autonumber field,
or rank the data on the primary key.
Hoping it may help,
Vanderghast, Access MVP
> Anybody know how to include a column which just increments by 1 for each
> row
> that the query generates?
>
> Thanks!
mf_sina - 16 Aug 2006 05:40 GMT
thanks Vanderghast
it was my question too
your answer worked fine
> Hi,
>
[quoted text clipped - 10 lines]
>>
>> Thanks!