Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Sorting
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...- nutshell
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Compare records in two tables
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...- nutshell
- Post #6
- Forum: Microsoft: Access Other topics
