More specifically, can you use the techniques you used to create Filter and Sort cases ("MySQL") to print a report with that code?  I'd like the user to be able to print a report just like the filter or sort option they chose.

---

Reply from Richard Rost:

Just use the WHERE clause of the SQL statement that you create in the Docmd.OpenReport command to open the report. You can do it direct in the VBA code like I show in my SQL SEMINAR, PART 2, or you can use a button macro like Access Expert 13.