Control breaks in access report?

K

Kelvin.Arcelay

Hello:

How do I go about defining a group control break in an access report.

For example data has:

division Vendor_id Vendor_Name Order_Number Amount
division Vendor_id Vendor_Name Order_Number Amount
division Vendor_id Vendor_Name Order_Number Amount
division Vendor_id Vendor_Name Order_Number Amount
division Vendor_id Vendor_Name Order_Number Amount
division Vendor_id Vendor_Name Order_Number Amount
division Vendor_id Vendor_Name Order_Number Amount


Report within the same page should look like:

division Vendor_id Vendor_Name Order_Number Amount
Order_Number Amount
Order_Number Amount
Vendor_id Vendor_Name Order_Number Amount
Order_Number Amount
Order_Number Amount
division Vendor_id Vendor_Name Order_Number Amount
Order_Number Amount
Order_Number Amount
Vendor_id Vendor_Name Order_Number Amount
Order_Number Amount
and, in a new page:

division Vendor_id Vendor_Name Order_Number Amount
Order_Number Amount
Order_Number Amount
Vendor_id Vendor_Name Order_Number Amount
Order_Number Amount

Please advise,
 
R

Rick B

Then set up GROUPING and use your group headers. Group by division, then
Vendor_id. It could then look like...

division
vendor_id vendor_name
order_number
amount
order_number
amount
order_number
amount
vendor_id vendor_name
order_number
amount
order_number
amount

division
vendor_id vendor_name
order_number
amount
order_number
amount
order_number
amount
 
Top