Trying to setup a query that I can ask the user from a form if they want to see only the records with "purchase dates" or "no purchase dates" or "show both". I have been able to put in a hard coded "Is Null" or "Is Not Null" which works for the first two choices but I have not been able to figure out a way to let the user decide from the form. I have played around with iif statements with no luck.
Is there a good place for beginner to get training on Querys
Thanks