update querry to renumber

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database of club members and each year members who left are taken
off and new members add to bottom on list and the table must than be
renumbered whereby current members move up and the new members are added.
 
Tables are not ordered. You have a value stored in a field or fields that
allow you to sort/order the records with a query.

Do you have a sample of before and after records that display your
requirements?
 
Duane Hookom said:
Tables are not ordered. You have a value stored in a field or fields that
allow you to sort/order the records with a query.

Do you have a sample of before and after records that display your
requirements?
Click to expand...
 
There are two numeric fields - one called last number and one called current
number. This is someone else database which I am trying to figure out what
she was doing. There is a querry but it puts the new members numbers on the
top starting at 1 instead of adding to the bottom. e.q. 100 members and I
would delete member 5 than the current 99 members would move up one number
and the new member would become member 100.
Thanks for your help.
 
Could post the SQL view of the query? How about providing field and table
names and some sample records (maybe about 10)?
 
Back
Top