View Full Version : Filter report by performing searching operation


libby
06-04-2009, 01:08 PM
Hi all,

I'm new in creating report using Access, and I have some problem here.
What I need to do is to create a report of sales by customer name.
First user should be able to type in the name of customer and it will display the list of all the customer whose name containing that parameter. For example "William" then all the customer whose name contains "William" will appears in the list.
Next user choose one of the customer in the result list and the report that list all the sales record for that customer.
I've created a query with name as parameter, but I don't know how to perform the search so that user can choose from the search result.

Please help me. Thank you so much.

-libby-