Labels with a grouping

[Scott]

I have a database for a school. I have a table for
students and a related table for family containing parent
info. I need to print labels (5660) that shows a parents
name and underneath shows their childrens names.
Therefore, I created a grouping based on the family number
in the students table. So, my parent name shows up under
that detail and the students names appear under the normal
detail. The problem is that I don't know how to make this
data fit into the label parameter. I need it to print
onto 10 2x4" labels per page whether there is one child or
five children. Can anyone help?

Familiar with VBA.

 

[Duane Hookom]

It would help a ton if you would type a few samples of records and expected
results. If you want to concatenate childrens names together, you can find a
sample of how to do this at
http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'
(careful with the wrapping).

 

[Jeff Boyce]

Scott

One possibility would be to use a query to concatenate all the data into one
field, then build a label report that uses that single field.

Good luck

Jeff Boyce
<Access MVP>

 

[Larry Linson]

I'd suggest the most likely solution is to create a Report using the Parent
Information as the Detail (using Force New Page before the detail), with a
multi-column Subreport for the Childrens' information. It'll take some trial
and error, but I think you'll be able to line up the detail so that it will
work. Just remember a multi-column report in a Subreport won't work unless
it is "across-then-down". And, either be very cautious using Can Grow / Can
Shrink or don't use them.

Larry Linson
Microsoft Access MVP

 

[Scott]

I think your code is what I am looking for, however, when
i run the query i am getting a bug at

Set rs = db.OpenRecordset(pstrSQL).

Can you help me in this matter? I am running DAO.
Thanks. Oh, here's an example of what I want the label to
look like:

MomFirstName MomLastName or DadFirstName DadLastName

Child1FirstName Child1LastName 2nd Grade
Child2FirstName Child2LastName 4th Grade
Child2FirstName Child2LastName 8th Grade
etc.

The Mom and Dad Names are in the parent Family Table while
the kids are in a Students table.

It really sounds like your solution will work for me, no?

 

[Duane Hookom]

If you want this type of format, I would recommend a subreport in the main
report. The subreport would display the child records and the main report
would contain unique records by parent.