Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
want to save the record number in a field
0 views
Skip to first unread message
fransquest
Nov 24, 2009, 1:33:03 PM11/24/09
to
This shold be simple, but I can't find and info on it. When starting a new
record I would like to populate a field with the record number and save it in
in the table.
record I would like to populate a field with the record number and save it in
in the table.
KARL DEWEY
Nov 24, 2009, 1:43:03 PM11/24/09
to
Record numbers you see at the bottom of the display are 'relative' only.
Access stores records like a barrel of bricks, all in a jumble. You have to
sort the records in a query, form, or report.
But you can use a field with an Autonumber to number records. The numbers
may not be continous without gaps but will be a unique value.
Access stores records like a barrel of bricks, all in a jumble. You have to
sort the records in a query, form, or report.
But you can use a field with an Autonumber to number records. The numbers
may not be continous without gaps but will be a unique value.
--
Build a little, test a little.
John W. Vinson
Nov 24, 2009, 10:04:17 PM11/24/09
to
What do YOU mean by "a record number"? Access doesn't have record numbers, so
you'll need to implement it yourself. Do you want a number assigned
sequentially in order of data entry? What if a record must be deleted: should
all later records get renumbered? Immediately, or can you do it in a batch
process periodically? If you change the order of records do you want the
record numbers to resequence? What specifically do you want these record
numbers to do for you?
--
John W. Vinson [MVP]
0 new messages