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.
Question QUESTION: 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)? IMAGE: Sample Access Report
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
---------- FOLLOW-UP ----------
QUESTION: Where exactly would I apply the filter when running the report?
Thanks!
Answer Again, it depends on how you run the report. I need to know that to advise.
Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: MS Office Access 2007 VBA
Excuse me? I just saw your ratings and I must take exception to them. There are different ways to filter a report. What would be the best way depends on how you are calling the report. I asked you for that information. If my responses weren't helpful its because you didn't give me the information I needed to help. I don't know how you could downgrade my knowledge when you didn't allow me to show it by giving me information. I have proven my extensive knowledge of Access over and over.
If you want help you have to supply the helper with info. If you don't, don't blame then that they couldn't help.
){kind=link}