If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
Display Row Number in Datasheet View
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. |
#2
|
|||
|
|||
Display Row Number in Datasheet View
On Thu, 11 Feb 2010 12:07:02 -0800, 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. 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] |
#3
|
|||
|
|||
Display Row Number in Datasheet View
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 -- |
#4
|
|||
|
|||
Display Row Number in Datasheet View
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. |
Thread Tools | |
Display Modes | |
|
|