record numbering

  • Thread starter Thread starter Ward
  • Start date Start date
W

Ward

I'd like to add a field to a query that will put a
sequential number for each record. Can this be done in
Access?

Thanks
 
Hi,
I'm not sure how (if) this can be done with a query.
However, here are a few ways to create a similar effect:
1. if you need an incremental numbering field on a table,
create a field with type = AutoNumber and NewValues =
Incremental.
2. If you need to number the records on a Report (for
printing), you can: 1.create an unbound textbox. 2. set
it's Value property to "=1" . and 3. set the Running Sum
property to Over Group (or Over All if this is the desired
effect).
3. when i wanted to add a Serial Number field (to keep my
Order Details in the right order inside each Order) i
placed the field in the Order Details subform, and then
set placed this code in the form's Current event:
Me![SerialNo].DefaultValue = Me.RecordsetClone.RecordCount
+1

I hope at least one of these options meet your needs :)
Ayelet
 
Back
Top