Hello all:
I set up a QBF using the example on the Microsoft website.
I have 9 criteria in my query, example of one criteria is:
Forms![QBF_Form]![Sales_center] Or Forms![QBF_Form]![Sales_center] Is Null
In the query design view, I placed each of these criteria in the different fields on a different row in the query because the user may or may not fill in each field in the form, is this correct? I also tried placing the criteria side by side in different columns/fields.
But when I click the command button on my Form, the query is not working properly. I found out that if I have only 3 fields with criteria, it works okay, but when I increased the number of criteria fields to 9, it does not work as well. Would an SQL statement work and if so, could you show me how to set it up?
I also noticed that when I close and open the query, the criteria above is split into two, the last part of it is pasted into a newly created field, could this be the problem and how can I work around it?
I set up a QBF using the example on the Microsoft website.
I have 9 criteria in my query, example of one criteria is:
Forms![QBF_Form]![Sales_center] Or Forms![QBF_Form]![Sales_center] Is Null
In the query design view, I placed each of these criteria in the different fields on a different row in the query because the user may or may not fill in each field in the form, is this correct? I also tried placing the criteria side by side in different columns/fields.
But when I click the command button on my Form, the query is not working properly. I found out that if I have only 3 fields with criteria, it works okay, but when I increased the number of criteria fields to 9, it does not work as well. Would an SQL statement work and if so, could you show me how to set it up?
I also noticed that when I close and open the query, the criteria above is split into two, the last part of it is pasted into a newly created field, could this be the problem and how can I work around it?
Last edited:
