Sure, sorry if I wasn't explaining it right.
You see how the dropdown on my screenshot shows June 26?
The user as you can see in the bottom list already registered. So that June 26 date should not be there as a choice now.
What you can't see in the dropdown (because it's closed in the shot), is that August is also available. That one would be correct and is the only date that should be available to the user.
I looked at your screenshot. It shows a return of May1, June 26 and August 28.
The user as mentioned above should only be seeing August 28.
The query is doing what it's being told and filtering out the UserID = 5. But since userid 6 has registered for dates = to dates that userid 5 has, I need those gone too because I don't want userid 5 to re register for the same dates.
Sometimes things sound correct in my head but I am saying the wrong. I can try to explain this a different way if needed. Sorry for the rambling.
Basically what I need is a filter that says, remove all UserID = 5 AND also remove all other records which have a date = to any of the records with the UserID of 5. :)
Thanks,
TroyD