Trouble on Monthly Statement

[Mitt1]

I have created a report showing a list of all payments a customer has made that month. I have created a query to search for the month and return the payments, although it is returning the payments for every customer. Is there a way I can just show all the payments for one specific customer (along with their balance from last month (I have this data stored in the customer table)).

thanks

 

[pbaldy]

You can use a parameter query to restrict the query to one customer or this method to filter the report:

http://www.baldyweb.com/wherecondition.htm