Return unique clientID

[Albert1955]

Hello
I have a query to find only the unique clients that have attended an event during a time period
I can only get the event and client for each event
So i want a query that returns the clientID for any client that attended any event.
havr tried using the return unique values in the property sheet but that still gives me multiple clientIDs with each event they attended

Its confusing me like crazy
any help gratefully accepted
Albert

 

[CJ_London]

You have 2 options:

Change your Date Event column from Group By to Where and ensure the show box is not ticked and change unique values from yes to no

or

Remove the totals line (i.e. the group by's) and untick the show box for the date event column - and leave unique values as yes

This will then just show all clients who have attended an event between the dates selected

 

[Albert1955]

Thanks it works perfectly now
just what i wanted
thanks again
A