Format a report and new pages

  • Thread starter Thread starter Stu
  • Start date Start date
S

Stu

Hi.

I'm very new to Access/Visual Basic so please forgive my ignorance.

The application that I'm attempting to construct is a simple customer
quotation database. Each quote has a quote number which is unique. Each
customer may have several quotes.

I'm trying to produce a report based on a simple query. The query goes along
the lines of...

When the user selects a customer from a combobox, return all the quotes
associated with that customer.

This works and returns the info that I'm expecting. The problem arises when
I'm trying to format the output to a report.

The report is formatted like so...

Customer
Quote Num
Items within the quote

This is currently being displayed as...

(Page header)
Customer
Quote Num (1)
(Detail)
Quote item 1 (from quote 1)
Quote item 2 (from quote 1)
Quote item 1 (from quote 2)
Quote item 2 (from quote 2)
Quote item 1 (from quote 3)
Quote item 2 (from quote 3)
etc...

This continues until a new page is reached.

What I would like to do is only have one quote per page and just the items
associated with that quote on the same page. When the next quote is
displayed this should be on a new page. As you can see, currently I'm only
having one quote number listed in the Page header and then all of the quote
items for all of the quotes listed in the Detail.

This is what I would like...

(Page header)
Customer
Quote Num (1)
(Detail)
Quote item 1 (from quote 1)
Quote item 2 (from quote 1)

New page.

(Page header)
Customer
Quote Num (2)
(Detail)
Quote item 1 (from quote 2)
Quote item 2 (from quote 2)

New page.

(Page header)
Customer
Quote Num (3)
(Detail)
Quote item 1 (from quote 3)
Quote item 2 (from quote 3)

New page.

I'm sure this is a simple dilemma, but I would really appreciate some
assistance.

Thanks,

Stu.
 
Stu,
You need to go to properties for your Quote Num Header
section. Change "Force New Page" to Before Section.
 
Stu said:
The application that I'm attempting to construct is a simple customer
quotation database. Each quote has a quote number which is unique. Each
customer may have several quotes.

I'm trying to produce a report based on a simple query. The query goes along
the lines of...

When the user selects a customer from a combobox, return all the quotes
associated with that customer.

This works and returns the info that I'm expecting. The problem arises when
I'm trying to format the output to a report.

The report is formatted like so...

Customer
Quote Num
Items within the quote

This is currently being displayed as...

(Page header)
Customer
Quote Num (1)
(Detail)
Quote item 1 (from quote 1)
Quote item 2 (from quote 1)
Quote item 1 (from quote 2)
Quote item 2 (from quote 2)
Quote item 1 (from quote 3)
Quote item 2 (from quote 3)
etc...
Click to expand...


Use Sorting and Grouping (View menu) to create a group on
the Customerfield and a second group on the quote number
field. Select Yes for Group Header (in the lower portion of
the window) for both groups. Then move the Customer text
box to the customer group header and the Quote number text
box to its group header. You may not need the page
header/footer at all.

You can set the ForceNewPage property of the group headers
section to get each customer and/or qoute to start on a new
page.
 
Back
Top