Autonumber a query

[Sandworm]

I want to create a query field that automumbers the dataset from (1 to inf). looked on access help but cant find what im looking for - anyone help. Is it just a simple operator Im not aware of?

Thanks in advance.

 

[Trevor G]

You can download a sample query database from Microsoft which has a numbering system option in a query. Here is a link.

http://www.microsoft.com/downloads/...5B-A8BA-4C2B-BAB7-EEA1F953C040&displaylang=en

 

[Sandworm]

Thanks for the suggestion Trevor unfortunately I currently only have internet access over a very limited wireless network and it wont allow me to download anything like .mdb currently or most other things come to think of it.
Any chance you could paste a screen shot or give a brief explanantion of the query set up so I could try to reproduce it?
Thanks in advance.

 

[Trevor G]

Try doing this.

Create a query from your data, simply select fields then save query, qryNumbers, then create a report based on the query, add an extra textbox to the report and in the properties you would adjust the control source to =1 then look down the properties until you find running sum then cahnge No to Overall. this will number each record from 1 to the last record you display in the report.

If you have limited dialup then this is the best I can suggest for now.