1. Open your report in design view.
2. Open the Sorting'n'Grouping dialog (View menu).
3. Choose the Vendor field in the Sorting'n'Grouping dialog.
In the lower pane, set Group Heading to Yes.
Access adds the Group Header.
4. In the Detail section of your report, add a text box with this
properties:
Control Source =1
Running Sum Over Group
The text box will increment by 1 within the group.
If you really need to generate the "1.1" style, it would be possible with a
running sum text box in the group header, hide the one you added to the
Detail section, and then add another text box to display:
=[BoxFromHeader] & "." & [BoxFromDetail]
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Rob" <ch*******@yahoo.com> wrote in message
news:60**************************@posting.google.c om...
I have an access 2000 application.I generate a report with Query
as the recordsource.This report is the analysis of data Vendorwise.The
vendors are listed in ascending order alphabetically,like
AT&T,CTI,DALLAS...Verizon etc.At present in my report,I have a running
serial number 1,2 etc.But i need to have a numbering where if there
are 5 items of AT&T,it will be 1 to 5 and then if the next vendor is
ACT it should again start from 1.Hope you understand what i am trying
to achieve here.Is this possible in a query?
Or is it possible to have something like this?
1)AT&T
1.1)
1.2)
2)ACT
2.1)
2.2)
Thanks for all the help
Rob
