I have 2 selection boxes, 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.
My code reads as follows:
ORDER BY[Contacts].[PrimaryCandidate], [Contacts].[LastName], [Contacts].[AlternativeCandidate], [Contacts].[LastName];
My problem is how to add another:
arguement or how to best word it embedded in the above code.