S
SMelissaK
Hi,
Management has recently asked us to separate cases deemed "aged" into
different criteria depending on the weight of the case. This is hard because
the ages involve two different calculations depending on what the case has
been through (long story).
Now I have to develop a query that will separate the aged cases into four
different tiers with different criteria. I have a query with the following
multiple criteria for AGE and WEIGHT:
And so on. It works except that I can't include the set of cases for which
the age calculation is different.
I made another query based on a union query so the two different
calculations can be incorporated. The age number is a number type and the
weight field type is a text type, just as it is in the other query. If I
base another query on this union query, it will not let me enter the multiple
criteria as above. It tells me there is a data type mismatch in the
criteria.
BUT ifI create a query from the union query with just one criteria, i.e.
only the >120 Like "1" it comes out okay. Hope I've made myself clear.
What gives? I hope I don't have to create queries for every single age
designation of every single tier.
Management has recently asked us to separate cases deemed "aged" into
different criteria depending on the weight of the case. This is hard because
the ages involve two different calculations depending on what the case has
been through (long story).
Now I have to develop a query that will separate the aged cases into four
different tiers with different criteria. I have a query with the following
multiple criteria for AGE and WEIGHT:
And so on. It works except that I can't include the set of cases for which
the age calculation is different.
I made another query based on a union query so the two different
calculations can be incorporated. The age number is a number type and the
weight field type is a text type, just as it is in the other query. If I
base another query on this union query, it will not let me enter the multiple
criteria as above. It tells me there is a data type mismatch in the
criteria.
BUT ifI create a query from the union query with just one criteria, i.e.
only the >120 Like "1" it comes out okay. Hope I've made myself clear.
What gives? I hope I don't have to create queries for every single age
designation of every single tier.