Row Numbers in a Query or Form ?

jdowski

Board Regular
Joined
Apr 21, 2002
Messages
235
Hi Folks,

I know how to put row numbers in a report. What I'd like to know is if there is an easy way to put row numbers in a form, (either continuous or datasheet) or perhaps create the row numbers in the underlying query that feeds the form.

Thanks, :p

Joe in Oxford, CT. USA.
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Maybe there's a better way, but:

The only way I can think of doing this is to actually dump your desired information into an output table which is then used as the basis for the report. Seems a little cumbersome to have to do that though. Technique is pretty simple, just setup a counter as you write and use it for a field.

Mike
 
Upvote 0

Forum statistics

Threads
1,221,825
Messages
6,162,190
Members
451,752
Latest member
majbizzaki

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top