how to keep serial numbers same even after deleting a record;

G

Guest

suppose v have 4 record in a table n v delete record 2,then the autonumber
serial feild will be 1,3,4 and not 1,2,3 y?? bcoz nw only 3 record remain
after deleting 1 record (record no2 for instance);one more question how do v
sort according to priority,suppose a feild called designation has the
values-supervisor,painter,helper etc n i need the supervisor to be the 1st
record even if painter is supposed to be alphabetically on top after
sorting...iam using access2002.
 
F

fredg

suppose v have 4 record in a table n v delete record 2,then the autonumber
serial feild will be 1,3,4 and not 1,2,3 y?? bcoz nw only 3 record remain
after deleting 1 record (record no2 for instance);one more question how do v
sort according to priority,suppose a feild called designation has the
values-supervisor,painter,helper etc n i need the supervisor to be the 1st
record even if painter is supposed to be alphabetically on top after
sorting...iam using access2002.
Click to expand...

What might be appropriate in an e-mail between friends is not
appropriate in a technological newsgroup with many readers to whom
English is a second language.

If you care to re-write your message, using full words, punctuation,
and proper capitalization so that everyone who reads your question can
understand it, you will have a much better chance of getting a
helpful reply.
 
G

Guest

Ok first off autonumber assigns a number automatically when the record is
created. It is not a record count.

Second if you want to sort I find it easy to make a extra column in the
table and order from 1-10 how you want it ordered then in the form use the
query builder to order it according to the new column without showing it.
 
Top