473,231 Members | 1,384 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,231 software developers and data experts.

Numbering in Report

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
2 1866
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Wayne Aprato | last post by:
I have a report that shows the results of a query. One of the fields is an autonumber field from the query which shows for instance: 120, 121 , 122 for 3 records. Is there a way to have another...
2
by: Wayne Aprato | last post by:
I posted this yesterday and it seems like a moderator has thrown it in another thread. This is a totally different question to the one asked in that thread, so I'm posting it again. It is not a...
2
by: Elasho | last post by:
I have a report that groups data on an Area, the report is set to force a new page for each Area within the report. Each Area will have 1 or more pages. Is it possible to make the page...
1
by: Simon | last post by:
Dear reader, Most of the reports have a page numbering as Page x of nn, starting at the first page 1 (one) to the last page nn. But know I need to start with Page 1 of nn for each...
3
by: joelpollock | last post by:
I'm having trouble continuously page numbering a large report in MS Access. The report is made up of three separate Access reports which I join together at the end. In the past I have opened the...
1
by: seawolf | last post by:
Is there a way to create a numbering for the Details in an Access 2003 Report. For instance, if a report has 12 records that make up the Details in a report, can these be numbered, i.e., 1, 2, 3, 4,...
4
by: bhughes2187 | last post by:
I am trying to sequentially place page numbers across multiple reports. Basically what I am trying to do is on the first report, which has 3 pages, the first page is page one...after cycling through...
1
by: lawitt | last post by:
I have a MakeTable query whose resulting table i'm using in a crosstab query. The fields in the crosstab are constantly changing (weekly), so my ultimate goal has been to somehow create a dynamic...
7
by: Reedsp | last post by:
I have a report that displays the page numbering incorrectly. Example page 1 of 3 but only 2 pages are displayed when previewing or printing the report. Here is the details: Page footer - text...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.