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
<garvic82@discussions.microsoft.com> 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.