Hi,
I am using the Filter property in the Report Property Sheet and it is working great when filtering one field. However, I would like to filter by multiple fields at one time.
This is the syntax I am currently using in the filter property: Date_Due_In =forms![Purchase_Orders_Filter_Pop_Up_Form]![text16]
I have a form called 'Purchase_Orders_Filter_Pop_Up_Form' which the user uses to enter the value they would like to filter the report by. I have created it so there is the possibility of the user entering the 'product code' as well as the 'date due in' to filter the report by both fields. Is it possible to filter multiple fields at one time using the filter property or so the user can choose which option they would like to filter by?
Thanks for you help!
Chris
I am using the Filter property in the Report Property Sheet and it is working great when filtering one field. However, I would like to filter by multiple fields at one time.
This is the syntax I am currently using in the filter property: Date_Due_In =forms![Purchase_Orders_Filter_Pop_Up_Form]![text16]
I have a form called 'Purchase_Orders_Filter_Pop_Up_Form' which the user uses to enter the value they would like to filter the report by. I have created it so there is the possibility of the user entering the 'product code' as well as the 'date due in' to filter the report by both fields. Is it possible to filter multiple fields at one time using the filter property or so the user can choose which option they would like to filter by?
Thanks for you help!
Chris