remove repeating information

[Leong]

Hi

I have created a report and on the report there is repeating information. (please see attached)

as you can see it says LIMS055 twice, LIMS054 twice etc.

it is correct that there are two users in this department that need LIMS055 etc. However it would look more professional if it just displayed this information once.

 

[Michael J Ross]

Group By SOP_ID

 

[Leong]

Group By SOP_ID

thank you so much.

haha I am not the most effcient user is Access so could you point me to where i group by SOP_ID

 

[Michael J Ross]

Sorry I should have said, do it in the query that the report is based on.

 

[Leong]

Sorry I should have said, do it in the query that the report is based on.

okay thats great thanks