record position in the query

M

Mike

I am trying to make a query where I add a new field that returns the record
position (which does not exist in the orinal table).

For example, the table is:
apples
oranges
bananas

When I make the query, I want it to return:
1 apples
2 oranges
3 bananas

Does anyone have any ideas? This would be fabulous!
 
O

OfficeDev18 via AccessMonster.com

I don't know of any way to do it in a query, but it's easy to do in a report.

Interested?
 
J

Jeff Boyce

Mike

Records in Access tables have no inherent order. If you want to be able to
sort your table rows in some arbitrary order (i.e., not alpha, not numeric),
YOU have to include a field that you fill with the values on which you want
Access to sort. Then you have to use a query and sort by that field.

Regards

Jeff Boyce
<Office/Access MVP>
 
Top