Multiple Filtering/Sorting - Access with SQL

I have 2 selection fields, that when either are checked, I want them to generate information from that record onto a report. My SQL code is working for filtering one selection box, but I am having difficulties wording the code to also filer for the second arguement. Please help!

My code reads as follows:

WHERE ([Contacts].[AlternativeCandidate]<>No)
ORDER BY[Contacts].[PrimaryCandidate], [Contacts].[LastName], [Contacts].[AlternativeCandidate], [Contacts].[LastName];
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!