How to Leave Gaps in a Report

[Mondou]

I've created a report from a Table containing the following fields:
Item (Primary Key), Category, Description and Cost.
My report shows 6 items per page .

What I would like to do is to show all items from one category and
then start another category on a next page (For example, 10 items in a
category would show 6 on the first page and the other 4 on the second.
The next category items would start on the following page (third),
and so on.
.... Is it possible to do this without having to create different
tables for each category ?

Thanks in advance

 

[Jeff Boyce]

If you use the Grouping in your report definition and group by category, you
can set one of the properties of the group to start a new page after the
category.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Mondou]

If you use the Grouping in your report definition and group by category, you
can set one of the properties of the group to start a new page after the
category.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

Thanks Jeff,

But I am fairly New to Access and not sure what you mean by using the
Grouping in my Report Definition ... how do I do that ?
I am using Microsoft Access 2007.

 

[Jeff Boyce]

Consider checking Access HELP for Grouping & Sorting in reports...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

If you use the Grouping in your report definition and group by category,
you
can set one of the properties of the group to start a new page after the
category.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

Thanks Jeff,

But I am fairly New to Access and not sure what you mean by using the
Grouping in my Report Definition ... how do I do that ?
I am using Microsoft Access 2007.