Criteria for Parameter Query

[bdehning]

Is there a way to only have to enter partial criteria to make a query run?

For example, If I put [Enter Account Name] in the query criteria and an Account Name is ABC Contracting, is there a way to only have to enter ABC to make this account come up?

I only know of entering the entire name

 

[Ken Snell]

Use something like this for the query criteria:

Like [Enter Account Name] & "*"


--

Ken Snell
<MS ACCESS MVP>

Is there a way to only have to enter partial criteria to make a query run?

For example, If I put [Enter Account Name] in the query criteria and an

Account Name is ABC Contracting, is there a way to only have to enter ABC to
make this account come up?

 

[bdehning]

Thanks Ken

Worked Great
--
Brian

Use something like this for the query criteria:

Like [Enter Account Name] & "*"


--

Ken Snell
<MS ACCESS MVP>

Is there a way to only have to enter partial criteria to make a query run?

For example, If I put [Enter Account Name] in the query criteria and an

Account Name is ABC Contracting, is there a way to only have to enter ABC to
make this account come up?

I only know of entering the entire name

 

[kerrpmb]

I do not see why not, because if the system needs more information it should
prompt you on it.

 

[Arvin Meyer [MVP]]

Use the following expression in a query:

Like [Enter Account Name] & "*"

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

I do not see why not, because if the system needs more information it
should
prompt you on it.

Is there a way to only have to enter partial criteria to make a query
run?

For example, If I put [Enter Account Name] in the query criteria and an
Account Name is ABC Contracting, is there a way to only have to enter ABC
to make this account come up?

I only know of entering the entire name