Chronological Order

[ianripping]

I am accessing my database from an ASP application. This applicatio
looks at a report, then when a button is clicked, that record i
deleted and then the next one is brought up.

Is there a way to make the record numbers to rename themselves to 1 2
4 etc.

EG

I have: -

1 Ian
2 Katie
3 Hannah
4 Amanda
5 Chris
6 Jasmine
7 Leon

I then access my database and record number one is deleted.

I now want the database to look like this: -

1 Katie
2 Hannah
3 Amanda
4 Chris
5 Jasmine
6 Leon

Any ideas

 

[Wayne Morgan]

As long as the field is one you generate yourself, not an autonumber field,
you could run an update query to do this. If you are always going to want to
subtract one from the current value of all records, try something like this:

UPDATE Table1 SET Table1.Field1 = [Field1]-1;