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.

On Thu, 11 Feb 2010 12:07:02 -0800, garvic82
<(E-Mail Removed)> wrote:

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

John W. Vinson [MVP]

hi,

On 11.02.2010 21:07, garvic82 wrote:
> 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 <--

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

--
Build a little, test a little.


"garvic82" wrote:

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