duplicates in reports

  • Thread starter Thread starter susan
  • Start date Start date
S

susan

I am having trouble making a report from a query without
getting the duplicated records in the query. I need to
print off a directory with the household name and address
and phone number with the members of the household. The
address and last name shows up with every member of the
household.
 
Have you tried setting the Hide Duplicates property of the "Household"
fields to 'Yes'?
 
susan said:
I am having trouble making a report from a query without
getting the duplicated records in the query. I need to
print off a directory with the household name and address
and phone number with the members of the household. The
address and last name shows up with every member of the
household.
Click to expand...

I presume that you have a table with household name,
address, etc. and separate table for the members in a one to
many relationship (which is the right way to do it). The
report would then be based on a query that Joins the two
tables.

If that's your arrangement, then the report should use
Sorting and Grouping (View menu) to group on the household
ID (name?) with the household data in the group header and
the member data in the detail section.
 
Back
Top