Is there way to return the ordinal position of a value within a table? Let's say I have a table of phone numbers. Over time the table has had additions and deletions. The table has an autonumber ID field. If I sort by the ID field I'd like to know what position the number '555-1212' is in the table. Any thoughts?
- Ordinal number within a table Ed Reed
- Re: Ordinal number within a table Dan Nelson
- Re: Ordinal number within a table Jigal van Hemert
- Re: Ordinal number within a table Kapoor, Nishikant
- RE: Ordinal number within a table Kapoor, Nishikant
- RE: Ordinal number within a table mfatene
- Re: Ordinal number within a table Michael Stassen
- RE: Ordinal number within a table Jamie McCarthy