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.

 

[Larry Linson]

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.

 

[Larry Linson]

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.

Ah, it seems to be getting more and more difficult for me to express myself
clearly. I ask for details about your data and get a list of the names and
another report layout.

I am going to list assumptions: if any are not correct, the following
suggestions may not work, either. If any are NOT correct, you may want to
post the clarification I asked for earlier, and perhaps someone else will
make a suggestion. I rarely have the patience to ask for clarification more
than once.

Assumption 1: fname is the name of a customer
Assumption 2: a customer can receive deliveries of different grains, of
different grades
Assumption 3: if date has anything to do with this, you have already
selected by date, in your query
Assumption 4: for each grain, you want the name of the grain to show only
for the first detail of that grain.
Assumption 5: for all deliveries for the customer in this query, you want
the total weight, even if different grains.

In sorting and grouping, define a group on fname, with a header and a
footer -- sort order as you wish, though I'd think normal would be ascending
by fname.
In sorting and grouping, define a group on grain, with neither header nor
footer, or with header and footer, and don't place any data in either the
header or the footer.

In the fname header, place your label and the fname field.
In the detail associated with grain, place the grain field, the grade field,
and the net weight field.
for the grain field, set the hide duplicates property.
In the fname footer, place your label information and use the SUM function
to calculate the total weight for this fname. For the fname footer, set the
Force New Field Property to AfterSection.

Good luck.

Larry Linson
Microsoft Office Access MVP