Select Specific Record based on Absolute Value

[bam720]

Maybe I am missing something but here goes...
I have the database full of records. I am using a datagrid to view the database (becuase its in Pocket PC) and the info i can get from the datagrid is it's absolute position. I would like to know how to SELECT the already selected record in the datagrid to bring it up by itself, but the only paramter i can get is its absolute position. for eg:
Abs: ID:
0 1
1 2
3 4
4 9
5 11

So you see how the absolute value has no correspondance to the iD number. Thanks in advance

 

[dhookom]

Isn't this a PocketPC question?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[bam720]

well i was hoping that i could just write a SQL statement based on the infomration i did have.

 

[dhookom]

I assume missing the "2" in your abs column is a typo.

If you are looking for the SQL syntax to create a rank/sequence number in a query, you can use a statement like:

SELECT (SELECT Count(*) FROM tblNoNameGiven n
  WHERE n.ID <tblNoNameGiven.ID) AS AbsPos, ID
FROM tblNoNameGiven;

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]