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:
ORDER BY[Contacts].[PrimaryCandidate], [Contacts].[LastName], [Contacts].[AlternativeCandidate], [Contacts].[LastName];