Query for distinct member number

[Lauri]

i have a meeting that has mulitple events. I need to figure out who has registered for the meeting, but has not registered for one particular event. If I pull the member number for the correct meeting with the event <> the event I don't want, I of course get multiple records

member 1 event 2
member 1 event 3


member 3 event 1
member 4 event 1
member 3 event 2


I only want to know that members 1, 3 and 4 did NOT register for event 6, I don't care what they DID register for.

Thanks!

[LukeJ Innov]

Hi,

Create a query that allows you to search for events that e.g. are below event 6. Then you will only receive results that show the members that have not registered.

Regards
Luke