page break in report

[rkg]

I have a query with only 4 fields. Name, Product, Grade, and Weight.
I've set up a report that lists each name, the product, the total
weight for each grade within the product and a total for all weights.
The only problem I have is that I can't seem to force a page break
after each name. All names are listed within the report. I've tried
adding footers and using the properties page to force a page break
after section, before sections, and every other thing I can think of.
I'm sure I'm missing something very simple as I have done this same
thing in the past. Any help would be appreciated.

Thanks,
Ron

 

[Larry Linson]

I have a query with only 4 fields. Name, Product, Grade, and Weight.
I've set up a report that lists each name, the product, the total
weight for each grade within the product and a total for all weights.
The only problem I have is that I can't seem to force a page break
after each name. All names are listed within the report. I've tried
adding footers and using the properties page to force a page break
after section, before sections, and every other thing I can think of.
I'm sure I'm missing something very simple as I have done this same
thing in the past. Any help would be appreciated.

Firstly, "Name" is an Access reserved word, and should not be used as a
Field name -- it can "confuse" Access (yield results that we may not
expect). Change that to some other Field name.

If you clarify the structure and layout of your data, it might help.
Queries, among other things, "flatten" the structure of the data, so we can
only guess at the relationship between the fields in the Query. I'd rather
not go down any side paths pursuing my guesses, so please do clarify.

I suspect you will need to use the Sorting and Grouping... perhaps on the
"new name" Field, declare a Group Footer, even if you place no fields in it,
and in its properties set Force New Field to After Section. But, when you
explain your data, someone will likely be able either to offer a useful
suggestion, or will know the next clarification to request.

Larry Linson
Microsoft Office Access MVP

 

[rkg]

Firstly, "Name" is an Access reserved word, and should not be used as a
Field name -- it can "confuse" Access (yield results that we may not
expect).  Change that to some other Field name.

If you clarify the structure and layout of your data, it might help.
Queries, among other things, "flatten" the structure of the data, so we can
only guess at the relationship between the fields in the Query.  I'd rather
not go down any side paths pursuing my guesses, so please do clarify.

I suspect you will need to use the Sorting and Grouping... perhaps on the
"new name" Field, declare a Group Footer, even if you place no fields in it,
and in its properties set Force New Field to After Section.  But, when you
explain your data, someone will likely be able either to offer a useful
suggestion, or will know the next clarification to request.

 Larry Linson
 Microsoft Office Access MVP

My fields are fname, grain, grade, and net_weight.

I would like my report to look like this

Header
For the account of: fname
Grain #1
50,000 lbs.
#2
36,000 lbs.
Total Wt.
Delivered 86,000lbs
This is where I want to change pages for the next customer.

I can get everything to work except the page break.

Thanks,
Ron G.