Record Numbering

  • Thread starter Thread starter NFJim
  • Start date Start date
N

NFJim

OK I'm a newbie and I'm sure this is easy to do but I
haven't been able to figure it out yet. I have a simple
membership roster with the usual, last name, first name,
etc. as my fields. The first column is a record number,
just to show how many members we have. Now let's say I
have 49 current members and add a new member, this becomes
record number 50. Now when I do a alphabetical sort by
last name, the new record might end up somewhere in the
middle, and it still shows as record number 50. What I
want to happen is for the record numbers not to follow the
name, so to speak, but just indicate the total number of
records, in this case 1 through 50.
 
Jim,

The field that you are using for "record number" is a part of the membership
record, so, no, you cannot get it to change when you sort your form
recordset or table by another field. In addition, using the highest
number in that field to determine how many members you have will, at some
point, prove faulty. For example, if the highest number in the field
containing your "record number" equals 50, and then one or two members
resign and you delete them from your table, how many members do you have?
Not 50.

There are techniques available to provide *temporary* row numbers to rows in
queries and forms available in a downloadable sample database created by MVP
Stephen Lebans at: http://www.lebans.com/rownumber.htm .
 
Back
Top