Label Report - problems!!! 1

[SherryLynn]

I have a report which makes file labels relating to the clients. The labels have parameter settings to pull only those whose data information falls between two dates. The database tracks families and their children. On the entry form, each child is entered into their own record. I have two problems,

1. The label has the last name field and the first name field on it, but it only shows one of the children's names on the label. How can I get it to pull all the names onto the label with a comma in between them. The Report is pulled from a query.

2. The second thing the report is doing is printing duplicates of the family based on the query parameters. For instance, if on the form I have entered two incidents regarding 2 of the children , then I get two labels, one for each because the incidents fall within the date parameters. How can I get around this?

Thanks,
Sherry

 

[luceze]

What exactly do you want on the labels?

 

[SherryLynn]

On the labels I want the family (last) name, followed by each of the children's names listed on the label as well as the file number. It would look something like this:

SMITH, File#111888
John, Mary, Sara, James

It is only pulling one of the children's names, not all.

Help!

 

[SherryLynn]

I'm still hoping for some help with this one if anyone has ideas.

Thanks, Sherry

 

[rhnewfie]

Are each of the childrens names stored in their own field of the table?

If there are two incidents (one per child) does that result in two rows in the table?

RHNewfie There are 3 Types of People in the World
Those Born to Think Logically
Those that can Learn to Think Logically
Those that Shouldn't Try

 

[JoeMiller]

How are your tables set up? Do you have a family table that is linked to a children table and a parent table? Do you have a family table linked to a member table and members are flagged as children or parents? What kind of keys are in your db? You can do what you want but we need some more data to come to the answer..

Joe Miller
joe.miller@flotech.net

 

[SherryLynn]

I have two tables - a Family table and a Children table.

The family table tracks the family's last name, file number, etc. and a primary key is set to uniquely identify each family.

The children table tracks each child in the family. Each child has their own unique id. The family id field is linked to this table and links all the children together from one family. A child is only listed once, regardles of how many incidents he/she are involved in (only one row in the table).

Does this help?

Sherry

 

[JoeMiller]

Sherry,

I've built a sample database that shows you how to get what you need by building in a couple tables and including a special function to do what you need. If you give me your email address I will email it to you so you can see it.

Joe Miller
joe.miller@flotech.net

 

[SherryLynn]

Hi Joe,

Thanks very much. Can you email to both of these addresses?

yanch@escape.ca
syanchishy@gov.mb.ca

Thanks again.
Sherry