Prev: Website Integration
Next: Filling in voids in the id number
From: garvic82 on 11 Feb 2010 15:07
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.
From: John W. Vinson on 11 Feb 2010 15:47
On Thu, 11 Feb 2010 12:07:02 -0800, garvic82
<garvic82(a)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]
From: Stefan Hoffmann on 11 Feb 2010 15:49
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 <--
From: KARL DEWEY on 11 Feb 2010 16:01
>>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.
 | 
Pages: 1
Prev: Website Integration
Next: Filling in voids in the id number