Using VBA in Reports

[AT76]

I'm creating a report with a list of customers that responded YES or NO. All this info comes from a table that the report is created from. Some of the customers have no responded yet. I see one can build an event in a report. My question is how do I refer to a specific field (in this case RESPONSE "YES/NO") and output in the report on ly the customers that have responded.

Thank you.

 

[MacCaillean]

Hi AT76

Instead of the whole table, you need to base your report on a query that includes only those RESPONSEs that are not null.

Regards

Mac

 

[AT76]

Thanks for your suggestion. You were correct!