numbering records in a query

[choppysuey]

Hope this is the right forum to ask this question. I'm trying to write a simple query based upon a single table and all I want is an extra column in the query that numbers the records in the query starting with 1 and ending with the number of records in the query. i.e if four records in the query then:
RecordNum SampleID Date
1 ...
2
3
4

I've tried using the count and sum function in the query but can't get it to work. Any hints?

Thanks in advance.

 

[traingamer]

See faq in the query forum: faq701-1155

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[dhookom]

Since this is a reports forum, add a text box to your report's detail section:

Control Source: =1
Running Sum: Over All


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]