Want to open a report and find SPECIFIC data to display? You can't do it with the Command Button Wizard like you can with forms. I'll show you a trick for opening REPORTS and showing specific data. Here's a link to the tip:

- Open a Report and Find Specific Data to Display

I cover this technique in my Access 202 and 204 classes.

Enjoy.

New Access Tip Open Report Upload Images   Link  Joni Moore  8 years ago 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. Read More... 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. Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

New Access Tip Open Report Upload Images   Link  Zerouil  10 years ago very helpfull tips thank you very much. Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

Access2003 or 2007 Upload Images   Link  Palden Tshering  11 years ago I have two tables. One for amount Due from Jan field to Dec field, and another for payment i,e form Jan to Dec field. I want to individual total up separately for tables, and then create combine report, but not able to do, help me to solve the above Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

Access Tutorial Upload Images   Link  Amos Lucas  11 years ago I would like to learn about split access form Reply from Richard Rost: That's coming in my new Access 2007 tutorials. New ones this coming week. If there's anything SPECIFIC you want to see, post it here. Read More... Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.