I have set up a parameter query with multiple criterias. I have also set it up so the query will accept a null response from the user. I have done this by using the following string in the criteria section:
[rma?] Or Like [rma?] Is null
This works fine except how do I apply this theory to a date range in the criteria? This is what I tried but it does not work properly:
Between [Begin Date?] Or Like [Begin Date?] Is null And [End Date?] Or Like [End Date?] Is Null
Any suggestions of how to make this work and return the proper data if the search dates are not entered?
Appreciate any help!
B&R
[rma?] Or Like [rma?] Is null
This works fine except how do I apply this theory to a date range in the criteria? This is what I tried but it does not work properly:
Between [Begin Date?] Or Like [Begin Date?] Is null And [End Date?] Or Like [End Date?] Is Null
Any suggestions of how to make this work and return the proper data if the search dates are not entered?
Appreciate any help!
B&R
