record position in the query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
I don't know of any way to do it in a query, but it's easy to do in a report.

Interested?
 
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>
 
Back
Top