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>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I query multiple data values in same field? 1
Oranges, Apples and Bananas...Selective Query! 9
Macro to add Multiple rows in same sheet 1
Query to return a value of occurences 1
Access MS Access Help with Select Distinct(count field) 0
How to choose maximum value 7
max 7
MAX 11

Back
Top