numbering items in an changing report (Access 97/SR1)

Topic

New Reply

All:

I have a report that I run on a monthly basis that ranks employees based on their production averages from previous months. I am wondering if there is a way to add a control to the report that will number the detail lines in the report.

The report is sorted by Supervisor, then budget center, then by production average (descending). When the report runs, I will get something like:

		John Doe
	Center 60111
			Jimmy		5.00
			Susie		4.99
			Billy		4.73
			Tommy		4.37
			Rachel		3.97

and what I would like to see is:

		John Doe
	Center 60111
		1	Jimmy		5.00
		2	Susie		4.99
		3	Billy		4.73
		4	Tommy		4.37
		5	Rachel		3.97

Where the numbering starts over at one (1) at every change of budget center.

Is this even possible? from withing the query?, the report?, or from code?

Any and all is greatly appreciated.

Reply | Quote

Replies

OOPS! I meant to attach this sample for anyone to look at.

Musta been

Reply | Quote

Steve,

Just add a text box to the appropriate section and set its DATE SOURCE to =1 . Set it to sum over the group.

Reply | Quote

I have a report where I put two text boxes in the detail section. One textbox is named txtrunningsum. In the properties for that textbox:
Control Source – =1
Visible – No

The other textbox is named txtnumber
Control source – [txtrunningsum] & “.”
Visible – Yes

The txtnumber textbox I put beside what I want to number. Hope this helps….

Reply | Quote

Thanks to all for you responses.

I got Preston’s solution to work. But, could not get Linda’s to work. the txtnumber textbox had a 1 in every detail record.

Reply | Quote

As an aside, Charlotte pointed out in a previous post that there is a great download to be found here. It is in Access 2000, but I’m sure if you poke around there is a version for 97. MS put together a sampling of neat things you can do in Access reports; specifically, they have a sample for exactly what you wanted to do in this post.

Reply | Quote