Parameter Query

[EVP]

Parameter Query - Can't believe I can't figure this out

This should be an easy one,

I have a parameter query on a form with two criteria options; works great.
I want the user to be able to type in the criteria so that it runs for all the criteria (or what would simply be a "xxxx" or "yyyy" query command). But they still need to sort it by either or.

I've tried many possibilities in the parameter query to no avail.
Any ideas?

 

[neileg]

Not clear what you mean. You can enter a criterion in two rows either for the same field or for different fields. This works as an OR operator but not an XOR. So the query will return records that match either the first or the second or both criteria.

Your use of the word 'sort' throws in a different dimesnion. Do you mean the query returns the right records, but the sort order is wrong?

 

[EVP]

Sorry for not being clear.

I have a parameter query box pop-up upon the opening of a form. Specifically, this query is used to differentiate Ineligible applications deemed so by either Vidacare or Medicaid (there are some applications deemed ineligible by neither, and so that field is blank). I want to enable the user to also query if an application is deemed ineligble by either of these (total applications deemed ineligible).

Is there an expression that can be typed by the user into the current parameter query to pull up these results?

No sorting is involved, sorry, my access language is not on par.

Thanks for your help!

 

[EVP]

Yes, that is what I am saying.
However, the only criteria for this query is : [Ineligibility Determined by VidaCare or Medicaid?]
as the parameter. I'm not using a control on the form.
If I type IS NOT NULL in the parameter box it puts quotation marks around it and won't pull up the non-null records. I'm simply looking for an expression that I can type or another way to write the query.

Any ideas?

 

[EVP]

Thank you Pat! I feel we're close, but the criteria is still not quite right. With this criteria, none of the queries work. I adjusted it, so now I can query for each criteria just as before, however I still can't get "both" to appear.

Thanks for your help!