I am using a form to execute a query. I need for the Query to accept multiply selections in a list box as the criteria. How can I set this up? Currently this is what I have in the query's criteria field: Forms![FrmReports]![List0]
Thanks
I am trying to create a formula in a query that will test the value range of another field and assign a value to the expression field.
For example:
=IIF( [ATB]![AGE] =BETWEEN 0 AND 30,30) ESLEIFF( [ATB]![AGE] =BETWEEN 31 AND 60,60.
Any help would be greatly appreciated......
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.