Filter Report

[BorisGomel]

Hello everybody,

I have a large append final table that is called FinalPaymentReport and I have created a report based on that table .The table has five fileds: ChecksNumber, DebtorName, Amount, Method , ClientsBank, and Date.


Also, I created a form with list box on it record source to ClientsBank and a sub from that it is table FinalPaymentReport . The from and sub from have master-child relationship based on list box and filed ClientsName.The problem is I am trying to figure out how to place two more filters on form to filter the records in table FinalPaymentReport and therefore in report .I need a user to be able to select clients name in list box( that is working now), then select date and method (method can be more than one to be selected –such as for example cash, local check, money order, cash check) to filter report. I read forum a lot but couldn’t find that if it is possible to have three filters on the form and use them at once to filter the report .

Thank you in advance for you help .

The Best Regards,

BorisGomel

[alansidman]

Create a query. Use the query as the record source for the report. Create a form (search form) to set the criteria (filters) for the query.

Look at this video for assistance.

http://www.datapigtechnologies.com/f...earchform.html

Alan

[BorisGomel]

Thank you Alan,

I got it . Instead of text boxes ,I created two list boxes and set them up following the example in the query . It wokrs very well.]

The Best Regards,

BorisGomel