Display Row Number in Datasheet View

  • Thread starter Thread starter garvic82
  • Start date Start date
G

garvic82

Can someone tell me how I can display the row numbers in a datasheet view
when a query is run? I have looked and looked and can not figure out where
and how I can do that. I just want it to display like a spreadsheet would
with the row and column numbers.
 
Can someone tell me how I can display the row numbers in a datasheet view
when a query is run? I have looked and looked and can not figure out where
and how I can do that. I just want it to display like a spreadsheet would
with the row and column numbers.
Click to expand...

Since a Table is not a Spreadsheet, it doesn't HAVE row numbers. They simply
don't exist, and they wouldn't be stable anyway if someone were to delete
records or present them in a different sort order.

You can easily put sequential numbers on a Report by including a textbox with
a control source of

=1

and set its Running Sum property to "Over All"; it's much harder, and data
dependent, in a Form.
 
hi,

Can someone tell me how I can display the row numbers in a datasheet view
when a query is run? I have looked and looked and can not figure out where
and how I can do that. I just want it to display like a spreadsheet would
with the row and column numbers.
Click to expand...
Normally this makes no sense, as Access is not Excel. Can you explain
why you want this kind of row/column numbering?


mfG
--> stefan <--
 
I can display the row numbers in a datasheet view
Add a field for it. Access does not store record (rows) by numbering. It
stores like a barrel of bricks and maybe displayed just as much a jumble
unless you sort on some field.
 
Back
Top