Page breaks in Access?

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Jen_Brown

Thread Starter
Joined
Jan 3, 2003
Messages
12
I have created a database for order entry. I am trying to do an invoice that will show each invoice number as a different page. All the correct data is on the report but each order line is on a seperate page rather than being grouped together for each invoice number. In the "detail" section, I have put "new page after this section" so that each page starts a new invoice number but it seems to have messed up the order lines.
Any ideas? I know it's something simple but my brain hurts!
 

Jen_Brown

Thread Starter
Joined
Jan 3, 2003
Messages
12
As an extra here is a snippet from the report I am trying to create. As you can see, the two order lines are being added seperately instead of together!

Address1 35 LONG LANE Invoice Number 23
Address2 TIVOLI Invoice Date 12/03/03
Address3 CHELTENHAM

Quantity Description Price

2 1.0 MM 6242Y £15.99

Sub Total £31.98

VAT @ 17.5% £5.60

Grand Total £37.58


5 2 GANG METAL £1.50
BACK BOX 35 MM

Sub Total £7.50

VAT @ 17.5% £1.31


Grand Total £8.81
Helppppppp!!!!!!!!!!!!:confused:
 
Joined
Oct 13, 2000
Messages
941
I'm not sure what your table structure is, but you probably need to add a grouping level for invoice number, put the grand-total figure in the group footer, and set Force New Page for the group footer to After Section.

It looks like you can have many part numbers for one invoice (this would, of course, be normal, but I have to guess from your data); the detail is always the lowest level, i.e. where there are the most records--if it's part number, and you set it to page-break after the detail, you'll get one part number per page.

Calling the total per part number "Grand Total" doesn't do much to help my understanding, incidentally. But that's neither here nor there... ;)
 

Jen_Brown

Thread Starter
Joined
Jan 3, 2003
Messages
12
Thanx for your help. I have kinda done it using the methods you suggest but had to create a few queries to get it to work exactly as I wanted. It's now finished and FANTASTIC!!!!!!!! (Well I think so in my limited experience!)

Once again, thnx for replying
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top