By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,107 Members | 1,323 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,107 IT Pros & Developers. It's quick & easy.

MS Access Query Auto Number

P: 1
I want to have a Serial Number field in a query which consists of continuous intergers (1 2 3 4 5 6....) so that my data is in a logical sequence.
How is it possible to do that please help
Jan 14 '08 #1
Share this Question
Share on Google+
3 Replies


FishVal
Expert 2.5K+
P: 2,653
Hi, there.

Do you want to dynamically enumerate records returned by the query or you need to store that numbers in the table?
Also, providing table the query based on metadata would be helpful.
Here is an example of how to post table MetaData :
Table Name=tblStudent
Expand|Select|Wrap|Line Numbers
  1. Field; Type; IndexInfo
  2. StudentID; AutoNumber; PK
  3. Family; String; FK
  4. Name; String
  5. University; String; FK
  6. Mark; Numeric
  7. LastAttendance; Date/Time
Regards,
Fish
Jan 14 '08 #2

P: 1
Hi, there.

Do you want to dynamically enumerate records returned by the query ...

Regards,
Fish
Fish,
I would love to know how to dynamically enumerate records in an Access query!
Would you mind posting how to do this?

regards,
Sven
Mar 11 '08 #3

FishVal
Expert 2.5K+
P: 2,653
Fish,
I would love to know how to dynamically enumerate records in an Access query!
Would you mind posting how to do this?

regards,
Sven
Hi, Sven.

Here in msg#2 you may find an answer.

Regards,
Fish
Mar 16 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.