aharmon,
You could use the .OrderBy property of your report to control the sorting rather than using a query. Remove the order by section from your query and attach the following code to the 'After Update' event of the option group (I have assumed its named lstReportCriteria_Attended. I have...
two suggestions
Using a subselect
SELECT Import.*
FROM Import
WHERE (BookName & Author & Price & Date) not in (Select BookName & Author & Price & Date FROM Books);
Using Left Join (similar to unmatched query wizard)
SELECT DISTINCTROW Import.*
FROM Import LEFT JOIN Books ON...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.