Hi Duane
The report has two groups - one group has a footer with a manual page break.
The detail section has variable data.
I tried to add the code in detail section_format:
txtNo=TxtNo+1
and in Page header format:
txtNo=0
This outputs a report with several missing numbers especially when there is a group header on the page.
Rajiv
---In MS_Access_Professionals@yahoogroups.com, <duanehookom@...> wrote :
Rajiv,
Is there anything in the data that creates a new page or is this somewhat random? Is the detail section of the report always the same height or can it grow?
Duane Hookom, MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Wed, 24 Jun 2015 13:24:26 -0700
Subject: [MS_AccessPros] Serial Numbers Access report
Hello All
I need to create report where each row in details section must have a serial row number.
I can do this by creating a textbox with control source =1 and assigning Running Sum over "group" or "over all".
The catch is that I want to create a running serial number that starts with 1 on each page of the report.
Any suggestions?
Rajiv
Is there anything in the data that creates a new page or is this somewhat random? Is the detail section of the report always the same height or can it grow?
Duane Hookom, MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Wed, 24 Jun 2015 13:24:26 -0700
Subject: [MS_AccessPros] Serial Numbers Access report
Hello All
I need to create report where each row in details section must have a serial row number.
I can do this by creating a textbox with control source =1 and assigning Running Sum over "group" or "over all".
The catch is that I want to create a running serial number that starts with 1 on each page of the report.
Any suggestions?
Rajiv
__._,_.___
Posted by: torajiv@gmail.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar