Expert: Scottgem - 11/11/2008

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)?

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.

Scott<>