Add a AutoNumber to a query

[Kenln]

Is there a way to add an AutoNumber to a query?

Since it is a query (rather than a table) the AutoNumber will always start at one and count up.

Anyone know how to do this???

 

[pbaldy]

See if this helps:

http://www.lebans.com/rownumber.htm

 

[HiTechCoach]

I think what you are wanting is to add record/row numbers, not really an autonumber field.

I normally handle this on a report if printing, not in the query.

It is possible to add Row numbers toa form/sub form or query.

See: Row numbers

 

[Kenln]

It took some playing but I think I have got it working.

Thank you,