single report page per customer

[daniel]

I need to generate a report that displays all of the information related to
one customer by a field in the table (say order number) on one page per
customer.

e.g. pg 1 Daniel Smith, order number 101 with details of the product and
price.

pg 2 Jerry smith, order number 102 with details of the product and price.

pg 3 etc


an order may have more than one line item. Can anyone help?

 

[KARL DEWEY]

Use Sorting and Grouping. Group on customer and force new page.

 

[daniel]

thanks - can access be set to do this automatically or do i have to do each
one manually?

 

[KARL DEWEY]

I do not understand your question - do i have to do each one manually?

Did you do what I said to do to your report? Did you then run the report?

 

[daniel]

hi, I am very new to access so please forgive me.

I mean do I have to manually enter the force new page between every group?
If yes then this would lead to me manually inputing a page break after each
group.

I am using the grouping option but am unable to find the force new page
option - there is nothing in help! I will get this figured out - can you help
direct me to where I force new page?

Many thanks!!!!

 

[daniel]

please excuse the manual bit - i have figured that out now!

Can you direct me to the force new page option, many thanks!!!!

 

[KARL DEWEY]

Open the report in design view, click on menu VIEW - Sorting and Grouping,
click on your sort/group field in the Sorting and Grouping window. In the
bottom pane for Group Header set to Yes and close that window.
Click on the header and set Force New Page property to Before Section.

 

[daniel]

perfect - I managed in the end - thanks a realt lot!!!!!!