Grouping problem with labels report form

[Carol]

I am trying to print library catalog cards (3 x 5 in cards, 3 cards/sheet)
using a corresponding label form.

My record source is a query. I would like [FullTopic] to print at the top of
each card, and the details of as many records as possible listed underneath.

In Sorting and Grouping, with [FullTopic], I have Group Header=Yes, Group
Footer = No, Group On = Each Value, Group Interval = 1, KeepTogether = No.

[FullTopic] is placed in a GroupHeader section; record detail fields are
placed in the Detail section.

I have two problems when I run the report: (1) Each card has the details for
only one record. (2) [FullTopic] is printed only on the first card for that
[FullTopic] field.

I would appreciate any help. Thanks.

 

[Mark A. Sam]

Carol,

It seems like you set up your own formatting for the labels. Did you try
the Report wizard for Labels? You "should" be able to select a template for
your particular label setup and not worry about anything except placing your
fields and text where you want them.

God Bless,

Mark A. Sam

 

[Carol]

Thanks for getting back to me.

Yes, I did start with the Report Wizard. (Access 2000) It only allows for
sorting, but not grouping. That's when I started tweaking in the Design view.

Carol

Carol,

It seems like you set up your own formatting for the labels. Did you try
the Report wizard for Labels? You "should" be able to select a template for
your particular label setup and not worry about anything except placing your
fields and text where you want them.

God Bless,

Mark A. Sam

I am trying to print library catalog cards (3 x 5 in cards, 3 cards/sheet)
using a corresponding label form.

My record source is a query. I would like [FullTopic] to print at the top
of
each card, and the details of as many records as possible listed
underneath.

In Sorting and Grouping, with [FullTopic], I have Group Header=Yes, Group
Footer = No, Group On = Each Value, Group Interval = 1, KeepTogether = No.

[FullTopic] is placed in a GroupHeader section; record detail fields are
placed in the Detail section.

I have two problems when I run the report: (1) Each card has the details
for
only one record. (2) [FullTopic] is printed only on the first card for
that
[FullTopic] field.

I would appreciate any help. Thanks.

 

[Mark A. Sam]

I'm not really following about the grouping. Would it be so that a new
group starts on a new page? The add a group footer for {FullTopic] and on
its property sheet set the Force New Page property to "AfterSection" and the
Keep together property to "Yes". Also keep the foolter section to 0 height.
I think that will work if it doesn't mess things up.

IF that doesn't solve it, you may have to manipulate the data to group it
like you need by using a report temp table for the report recordsouce and
grouping the data the way you want it.

God Bless,

Mark

Thanks for getting back to me.

Yes, I did start with the Report Wizard. (Access 2000) It only allows for
sorting, but not grouping. That's when I started tweaking in the Design
view.

Carol

Carol,

It seems like you set up your own formatting for the labels. Did you try
the Report wizard for Labels? You "should" be able to select a template
for
your particular label setup and not worry about anything except placing
your
fields and text where you want them.

God Bless,

Mark A. Sam

I am trying to print library catalog cards (3 x 5 in cards, 3
cards/sheet)
using a corresponding label form.

My record source is a query. I would like [FullTopic] to print at the
top
of
each card, and the details of as many records as possible listed
underneath.

In Sorting and Grouping, with [FullTopic], I have Group Header=Yes,
Group
Footer = No, Group On = Each Value, Group Interval = 1, KeepTogether =
No.

[FullTopic] is placed in a GroupHeader section; record detail fields
are
placed in the Detail section.

I have two problems when I run the report: (1) Each card has the
details
for
only one record. (2) [FullTopic] is printed only on the first card for
that
[FullTopic] field.

I would appreciate any help. Thanks.

 

[Carol]

Oops. Sorry about this typo. I meant that I started with the Label Wizard. I
used this as the basis for further tweaking in the Design View, but can't get
the grouping to work.

Thanks for getting back to me.

Yes, I did start with the Report Wizard. (Access 2000) It only allows for
sorting, but not grouping. That's when I started tweaking in the Design view.

Carol

Carol,

It seems like you set up your own formatting for the labels. Did you try
the Report wizard for Labels? You "should" be able to select a template for
your particular label setup and not worry about anything except placing your
fields and text where you want them.

God Bless,

Mark A. Sam

I am trying to print library catalog cards (3 x 5 in cards, 3 cards/sheet)
using a corresponding label form.

My record source is a query. I would like [FullTopic] to print at the top
of
each card, and the details of as many records as possible listed
underneath.

In Sorting and Grouping, with [FullTopic], I have Group Header=Yes, Group
Footer = No, Group On = Each Value, Group Interval = 1, KeepTogether = No.

[FullTopic] is placed in a GroupHeader section; record detail fields are
placed in the Detail section.

I have two problems when I run the report: (1) Each card has the details
for
only one record. (2) [FullTopic] is printed only on the first card for
that
[FullTopic] field.

I would appreciate any help. Thanks.

 

[Carol]

Mark --

I tried your suggestions and a few other things and they didn't help. Maybe
I'm not explaining this well. My standard (8.5 x 11) contains 3 library
cards/labels. I used the corresponding label wizard to set up the report
(Access 2000), but the wizard wouldn't do any grouping. I tried to play
around with Sorting & Grouping, but I couldn't get it to work.

An example of what I'm trying to get is

[FullTopic]#1
Fields of Record #1
Fields of Record #2
Fields of Record #3 (or however many will fit on the card)

....next card/label
[FullTopic] #1
Fields of Record #4

....next card/label
[FullTopic] #2
Fields of Record #5 or whatever
Fields of Record #6 or whatever

....next page


I guess this is the long way of answering your question -- I would like the
new group to start on a new label. The ForceNewPage seems to just do that --
start a new page, which wastes cards/labels. The real problem I have is that
I can only get the fields for one record onto one card/label -- which I
assume is a grouping problem. Also, I would like the contents of [FullTopic]
to print at the top of every card/label, but it only prints when there is a
new [FullTopic].

I have never used a report temp table as a recordsource. Could you explain
briefly? Thanks again so much.

Carol

I'm not really following about the grouping. Would it be so that a new
group starts on a new page? The add a group footer for {FullTopic] and on
its property sheet set the Force New Page property to "AfterSection" and the
Keep together property to "Yes". Also keep the foolter section to 0 height.
I think that will work if it doesn't mess things up.

IF that doesn't solve it, you may have to manipulate the data to group it
like you need by using a report temp table for the report recordsouce and
grouping the data the way you want it.

God Bless,

Mark

Thanks for getting back to me.

Yes, I did start with the Report Wizard. (Access 2000) It only allows for
sorting, but not grouping. That's when I started tweaking in the Design
view.

Carol

Carol,

It seems like you set up your own formatting for the labels. Did you try
the Report wizard for Labels? You "should" be able to select a template
for
your particular label setup and not worry about anything except placing
your
fields and text where you want them.

God Bless,

Mark A. Sam

I am trying to print library catalog cards (3 x 5 in cards, 3
cards/sheet)
using a corresponding label form.

My record source is a query. I would like [FullTopic] to print at the
top
of
each card, and the details of as many records as possible listed
underneath.

In Sorting and Grouping, with [FullTopic], I have Group Header=Yes,
Group
Footer = No, Group On = Each Value, Group Interval = 1, KeepTogether =
No.

[FullTopic] is placed in a GroupHeader section; record detail fields
are
placed in the Detail section.

I have two problems when I run the report: (1) Each card has the
details
for
only one record. (2) [FullTopic] is printed only on the first card for
that
[FullTopic] field.

I would appreciate any help. Thanks.

 

[Mark A. Sam]

Carol.

When Access can't do something for me in a report, I create a special table
that I call a temp table to be the recordsource for the report. I use
append queries or programming to fill in the data. This is a controlled
format, but requires programming experience. It isn't something I can
explain, it is something I just do. Sometimes Access just won't do what you
hope it will do. I don't know that you can't. Sometimes it is just playing
around with the settings.

God Bless,

Mark

Mark --

I tried your suggestions and a few other things and they didn't help.
Maybe
I'm not explaining this well. My standard (8.5 x 11) contains 3 library
cards/labels. I used the corresponding label wizard to set up the report
(Access 2000), but the wizard wouldn't do any grouping. I tried to play
around with Sorting & Grouping, but I couldn't get it to work.

An example of what I'm trying to get is

[FullTopic]#1
Fields of Record #1
Fields of Record #2
Fields of Record #3 (or however many will fit on the card)

...next card/label
[FullTopic] #1
Fields of Record #4

...next card/label
[FullTopic] #2
Fields of Record #5 or whatever
Fields of Record #6 or whatever

...next page


I guess this is the long way of answering your question -- I would like
the
new group to start on a new label. The ForceNewPage seems to just do
that --
start a new page, which wastes cards/labels. The real problem I have is
that
I can only get the fields for one record onto one card/label -- which I
assume is a grouping problem. Also, I would like the contents of
[FullTopic]
to print at the top of every card/label, but it only prints when there is
a
new [FullTopic].

I have never used a report temp table as a recordsource. Could you explain
briefly? Thanks again so much.

Carol

I'm not really following about the grouping. Would it be so that a new
group starts on a new page? The add a group footer for {FullTopic] and
on
its property sheet set the Force New Page property to "AfterSection" and
the
Keep together property to "Yes". Also keep the foolter section to 0
height.
I think that will work if it doesn't mess things up.

IF that doesn't solve it, you may have to manipulate the data to group it
like you need by using a report temp table for the report recordsouce and
grouping the data the way you want it.

God Bless,

Mark

Thanks for getting back to me.

Yes, I did start with the Report Wizard. (Access 2000) It only allows
for
sorting, but not grouping. That's when I started tweaking in the Design
view.

Carol


:

Carol,

It seems like you set up your own formatting for the labels. Did you
try
the Report wizard for Labels? You "should" be able to select a
template
for
your particular label setup and not worry about anything except
placing
your
fields and text where you want them.

God Bless,

Mark A. Sam

I am trying to print library catalog cards (3 x 5 in cards, 3
cards/sheet)
using a corresponding label form.

My record source is a query. I would like [FullTopic] to print at
the
top
of
each card, and the details of as many records as possible listed
underneath.

In Sorting and Grouping, with [FullTopic], I have Group Header=Yes,
Group
Footer = No, Group On = Each Value, Group Interval = 1, KeepTogether
=
No.

[FullTopic] is placed in a GroupHeader section; record detail fields
are
placed in the Detail section.

I have two problems when I run the report: (1) Each card has the
details
for
only one record. (2) [FullTopic] is printed only on the first card
for
that
[FullTopic] field.

I would appreciate any help. Thanks.