Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

field which increments sequentially

Status
Not open for further replies.
martakeithy

martakeithy

Technical User
Nov 12, 2001
19
GB
Hi
I am working on a quiz database with tables which hold questions answers and results. I have a table which holds a question and its related answers and am using an autonumber field as its primary key. However I need a method by which I can number questions sequentially as they are entered 1,2,3...
I believe there is a property which can be used to generate numbers like this?
Does anyone have any suggestions as to how I can achieve this?
Thank you
Marta
 
Status
Not open for further replies.

Similar threads

breezett93
  • Locked
  • Question
Field is being rounded in the export process
Replies
17
Views
712
strongm
strongm
JayRo71
  • Locked
  • Question
Unable to sort date field
Replies
4
Views
276
JayRo71
JayRo71
BugZap13
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
239
mikrom
mikrom
Hanss
  • Locked
  • Question
Query which shows results?
Replies
2
Views
215
dhookom
dhookom
mhshane
  • Locked
  • Question
Query to find keywords in description field and give count
Replies
4
Views
278
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top