G
Guest
I have a questionnaire database that contains participant’s demographic
information such as age, salary range, employee type, age group, departments,
location, and managers. We want to be able to run reports that can show
participant’s responses based the combination of the above demographic
information chosen by user. For instance, if I type in 19 and below in the
“Age†field in the form and 9000 and less in the “Salary Range†field in the
form, only the participants that meet these specific criteria are included in
the report. On the other side, if nothing were entered in the form, the
report would include all of the participants’ responses.
I have tried to run a multiple parameter by entering
[forms]![formname]![age] or [forms]![formname]![age] Is Null in the query for
age, [forms]![formname]![salary range] or [forms]![formname]![salary range]
Is Null for salary range, and so on for the other demographic criteria in the
Criteria/Or section.
It worked well until I have 11 (which is all of my need for criteria) of the
same kind of criteria entered [forms]![formname]![fieldname] or
[forms]![formname]![fieldname] Is Null. I CAN’T open up the query in design
form anymore!!!!!!!!!!
Is there any ways that I can get around this problem? Am I doing it the
right way? Is that any samples I can look at? Thank you for advance.
information such as age, salary range, employee type, age group, departments,
location, and managers. We want to be able to run reports that can show
participant’s responses based the combination of the above demographic
information chosen by user. For instance, if I type in 19 and below in the
“Age†field in the form and 9000 and less in the “Salary Range†field in the
form, only the participants that meet these specific criteria are included in
the report. On the other side, if nothing were entered in the form, the
report would include all of the participants’ responses.
I have tried to run a multiple parameter by entering
[forms]![formname]![age] or [forms]![formname]![age] Is Null in the query for
age, [forms]![formname]![salary range] or [forms]![formname]![salary range]
Is Null for salary range, and so on for the other demographic criteria in the
Criteria/Or section.
It worked well until I have 11 (which is all of my need for criteria) of the
same kind of criteria entered [forms]![formname]![fieldname] or
[forms]![formname]![fieldname] Is Null. I CAN’T open up the query in design
form anymore!!!!!!!!!!
Is there any ways that I can get around this problem? Am I doing it the
right way? Is that any samples I can look at? Thank you for advance.