Duplicates in a Report? 1

[jtfrier]

I have a litst of name that im trying to print in my feild the name can be the same I need to pull all the names from the field to a report but I only want the name to show up once.

 

[AlexMidd]

Select "Sorting and Grouping" in the report design menu, select the name field under "Field/Expression" using the dropdown, then select "Yes" for "Group Header" or "Group Footer" (whichever you want). The records will be grouped by each name, i.e. each name only appearing once in the header or footer.

Have fun! )

Alex Middleton

 

[jtfrier]

I did that and It still lets names appear more than once.

 

[jtfrier]

Sorry never mind had to drag the header thanks.

 

[AlexMidd]

Put the name box in the header, if you haven't already done so.

Have fun! )

Alex Middleton