User Entered Expressions for the Query Criteria

[Guest]

Hello,

I'm designing a database that will be used in the office and I want the user
to have the ability to enter criteria from the parameter popup or a
form/table. It appears every time I try, the information entered is returned
as "text" and the logical functions don't work.

I want the query to be able to use "*" or logic statements such as "Unit 1"
and "Unit2" inside the criteria. I understand how to set the expressions to
do that in the criteria field, but I don't want to have the users open the
query to set the criteria.

The expression works fine directly in the Query Field Criteria. IE, in the
design view criteria I type in "*" or the logic expressions. However when I
try to enter the information in the parameter pop-up, or in a linked table,
it doesn't work. I believe the pop-up and table is giving the entire string
as text rather than a logic statement. It's linking it as "unit1 or unit2"
which is not found in the table instead of "unit1" or "unit2".

Is there a way to allow the user to submit the criteria in a form/table or a
pop-up parameter box instead of making them enter into the query and type it
in the criteria field?

Thank You.

 

[[MVP] S.Clark]

Elaborate on this: "It appears every time I try, the information entered is
returned as "text" and the logical functions don't work."

Post your SQL if you like.