duplicate names in field

[Guest]

I have run a query with Parent's Name and Children's Name. The parent's name
is listed as many times as the number of children they have. How can I have
the parent's name listed only once?

 

[Rob Parker]

You can't, in a query. This is a relational database, not a spreadsheet!

If you want/need to present the data listing the parent's name only once,
you can do that in a report (but not in a form) by setting the Hide
Duplicates property of the control showing the parent's name to Yes.

HTH,

Rob

 

[Guest]

Rob,
Thanks for your answer. I am trying to report a simple roster of Parent's
names, addresses, etc, plus all their children's names. I need to hide the
duplicate lines of the same family but still have all the children's names in
the one family entry. I can't hide duplicates in most fields, because a lot
of them are the same (city, state, zip, etc). Thanks for your time.
Lisa

 

[John W. Vinson]

Rob,
Thanks for your answer. I am trying to report a simple roster of Parent's
names, addresses, etc, plus all their children's names. I need to hide the
duplicate lines of the same family but still have all the children's names in
the one family entry. I can't hide duplicates in most fields, because a lot
of them are the same (city, state, zip, etc). Thanks for your time.
Lisa

I'd suggest using the Report's Sorting and Grouping property (right mouseclick
the square at the upper left intersection of the rulers and choose Sorting and
Grouping). Group By the family; make the group Header visible.

Put the family information controls in the group header, and the child
information in the detail section.

John W. Vinson [MVP]

 

[John Spencer]

YOu can use a report based on the parent and a sub report based on the
children.

Base the report on a distinct query that returns only the Parent
information. The subreport would use a query that returns the parentId
and all the children.

OR you can use Duane Hookom's concatenate function. He has a sample
database. Try using google on the name and the function name. I don't
have a reference to it available here.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================