Display Row Number in Datasheet View

[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.

 

[John W. Vinson]

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.

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.

 

[Stefan Hoffmann]

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.

Normally this makes no sense, as Access is not Excel. Can you explain
why you want this kind of row/column numbering?


mfG
--> stefan <--

 

[KARL DEWEY]

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.