AboutScottgem Expertise I can answer some questions on a wide variety of business applications, including MS Office, Lotus Smartsuite, Visio, Notes and many others.
Experience I have over 16 years of experience as an IT professional, supporting a wide variety of business applications.
Scott,
Please see my attached image. Once I've ran a report in MS Access, is there a way to filter the report so it shows a specific record? For instance, I only want to see and its corresponding data. Is there a way to turn a filter on so the other two email addresses are not shown?
If not, would there be an alternative method to achieving this result (i.e. adding a command button and VBA script to a Form, filtering records, then "Printing" those filtered records using the command button)?
Answer You can't do this from the report. But you can go back to how you run the report to apply a filter.
Depends on how you reun the report as to how to do it.
Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA