K
kdagostino
I am trying to build a query for my database for conference attendence. I
have a search Form with the different criteria to type in such as Month,
Year, Department, Sponsorship, Advertisement, etc.
I want the query to recognize when I type in only the month and year, and
bring back those values, ignoring criteria for other other fields (e.g.
bringing back all records in August 2005, regardless of what department,
sponsorship, or advertisement). In otherwords, when I don't type anything in
a search field, I want the query to ignore that as a criteria.
Can anyone help me with this?
have a search Form with the different criteria to type in such as Month,
Year, Department, Sponsorship, Advertisement, etc.
I want the query to recognize when I type in only the month and year, and
bring back those values, ignoring criteria for other other fields (e.g.
bringing back all records in August 2005, regardless of what department,
sponsorship, or advertisement). In otherwords, when I don't type anything in
a search field, I want the query to ignore that as a criteria.
Can anyone help me with this?