Control breaks in access report?

  • Thread starter Thread starter Kelvin.Arcelay
  • Start date Start date
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,
 
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
 
Back
Top