473,399 Members | 3,106 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,399 software developers and data experts.

MS Access Report with more than 1 Page

134 100+
I follow the invoice format from Nwind database.

In my Page Header I have company name, address along with Invoice No...etc

In my GroupHeader2 which contain Billing Address, Shipping Address along with other information, And the title column such as S/No, Item, Desp, Qty, Price, Amount. It almost take up half the page.


If the Invoice consist of more than 1 page, then it only print my Page Header
along with the detail section, this way I can print more detail, cos each item in the invoice can contain 3 rows.(Bypass the GroupHeader2)

Everything work to what my expectation, until on the 2nd page onward, I realize it print the Page header, but didn't print the title column such as as S/No, Item, Desp, Qty, Price, Amount. How can I force the only title column to print ? Any Suggestion ?
Dec 18 '06 #1
3 2236
MMcCarthy
14,534 Expert Mod 8TB
I follow the invoice format from Nwind database.

In my Page Header I have company name, address along with Invoice No...etc

In my GroupHeader2 which contain Billing Address, Shipping Address along with other information, And the title column such as S/No, Item, Desp, Qty, Price, Amount. It almost take up half the page.


If the Invoice consist of more than 1 page, then it only print my Page Header
along with the detail section, this way I can print more detail, cos each item in the invoice can contain 3 rows.(Bypass the GroupHeader2)

Everything work to what my expectation, until on the 2nd page onward, I realize it print the Page header, but didn't print the title column such as as S/No, Item, Desp, Qty, Price, Amount. How can I force the only title column to print ? Any Suggestion ?
Move what's currently in the page header into the report header section and move the column titles into the page header section.

Mary
Dec 19 '06 #2
jamesnkk
134 100+
Move what's currently in the page header into the report header section and move the column titles into the page header section.

Mary
Thanks for your valuable advise
Dec 19 '06 #3
MMcCarthy
14,534 Expert Mod 8TB
Thanks for your valuable advise
You're welcome
Dec 19 '06 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Sami | last post by:
I hope someone will tell me how to do this without having to do any VB as I know nothing in that area. I am a rank beginner in using Access. I have created a database consisting of student...
15
by: Mark C | last post by:
All, I have exhaustingly been looking through the newsgroups in search of a way to systemically output an Access 97 report to a pdf file using the full version of Adobe Acrobat. I want the user...
9
by: Colin McGuire | last post by:
Hi, I have an report in Microsoft Access and it displays everything in the table. One column called "DECISION" in the table has either 1,2, or 3 in it. On my report it displays 1, 2, or 3. I want...
1
by: David Horowitz | last post by:
Hi folks. I need to create a report that has a Group Header that pulls certain data from the Detail section. It's something like this: +--Report---------------------------------------- |...
13
by: salad | last post by:
Hi Guys: I was stuck. I needed to send a report to a file. My beautiful report(s) in Access were going to require loss of formatting with RTFs, a PITA in WordMailMerge, sending it as a text...
52
by: Neil | last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server at the same time. We're moving to SQL Server...
8
by: babyangel43 | last post by:
Hello, I have a query set up in Access. I run it monthly, changing "date of test". I would like this query to be merged with a Word document so that the cover letter is created in Word, the fields...
1
by: siomay87 | last post by:
please help i have a problem in the ms access reporting, my report have: page header, detail, page footer and report footer In listing "detail section", the number of line is depend on the data...
1
by: sonicfun2006 | last post by:
I have SQL Server Database and MS Access 2003 is connected with ODBC. I have very large amount of records in various tables. The database is very dynamic as it changes every minute. I’m trying to...
4
by: lupo666 | last post by:
Hi everybody, this time I have three problems driving me nuts :-((( (1) I have a report with 20 or so Yes/No "squares". Is there a way to either hide/show the "square" or change the yes/no...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

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.