merging repeated data on query

[Pavilion]

hey folks, I am new to Microsoft Access ...

I used the many to many relationship to create this query. The patientinfo table is for personal information such as first & last name, date of birth, disease type, whether the patient is returning or not. The immunotable has what the patients are getting (type of therapy, date, whether they have switched to different formulation etc.) PatientAndTreatment is for linking the first two tables. When I was generating the query, I filtered out the people who are not returning back.



As you can see in the picture, the first three rows are dedicated to a single patient who received the therapy three times(same case for the last three rows). Is there any way to eliminate the repeated data? I need to be able to assess out how many patients are returning and what kind of therapy each returning individuals has been getting. This query make it look like 6 patients are returning while only 2 patients are actually returning.

thanks!

[June7]

Build a report based on the query. Textbox property HideDuplicates should do what you want.

[Pavilion]

sorry can you explain it in detail? What is texbos property hideduplicates??

[June7]

Create a report with the query as RecordSource. Bind textboxes to the fields. Select NameM textbox and look at the Property Sheet Format tab. The Hide Duplicates property is toward the bottom of the items. Set it to Yes

Or use report Sorting & Grouping features.