T
TESA0_4
I have a table where work done on aircraft is broken down into zones and
qualifiers applicable to those zones. For example 'fuselage' has qualifiers
such as 'front', rear', 'flight deck'etc.
Users need to query the data based on zone and qualifiers.
I have created a form where users can select zones and then get a filtered
list of qualifiers applicable to the zone. They have the option of selecting
up to three qualifiers for a zone. But I also want them to have the option
for selecting all records for a zone irrespective of qualifier. With this in
mind my form has a flag for selecting 'All Qualifiers'.
In the Design View for the query I have entered the following criterion for
the Qualifier field:
IIf([Forms]![frmAnalysis]![FlagAll]=-1, Like
"*",[Forms]![frmAnalysis]![QualifierA] Or [Forms]![frmAnalysis]![QualifierB]
Or [Forms]![frmAnalysis]![QualifierC])
If I enter a value in the form for QualifierA, B and/or C, the results are
fine. If no Qualifier values are entered and the Flag is set to Yes, the
query returns no records. Why is 'Like "*"' not returning a wildcard search
for any Qulaifier value?
Any sugesstions gratefully received.
qualifiers applicable to those zones. For example 'fuselage' has qualifiers
such as 'front', rear', 'flight deck'etc.
Users need to query the data based on zone and qualifiers.
I have created a form where users can select zones and then get a filtered
list of qualifiers applicable to the zone. They have the option of selecting
up to three qualifiers for a zone. But I also want them to have the option
for selecting all records for a zone irrespective of qualifier. With this in
mind my form has a flag for selecting 'All Qualifiers'.
In the Design View for the query I have entered the following criterion for
the Qualifier field:
IIf([Forms]![frmAnalysis]![FlagAll]=-1, Like
"*",[Forms]![frmAnalysis]![QualifierA] Or [Forms]![frmAnalysis]![QualifierB]
Or [Forms]![frmAnalysis]![QualifierC])
If I enter a value in the form for QualifierA, B and/or C, the results are
fine. If no Qualifier values are entered and the Flag is set to Yes, the
query returns no records. Why is 'Like "*"' not returning a wildcard search
for any Qulaifier value?
Any sugesstions gratefully received.