By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,705 Members | 1,795 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,705 IT Pros & Developers. It's quick & easy.

Numbering in Report

P: n/a
Rob
Hi,
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
Rob
Allen,
Thanks a lot.It worked like a charm.All you Access gurus and
MVP's who contribute here selflessly are wonderful people.

Rob


"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message news:<40***********************@freenews.iinet.net .au>...
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.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.