Display certain criteria.

J

John

How can I display certain criteria either in the query design or combo box.
For example. I have a list:
011Usa
012Usa
013usa
014usa
015usa

I want to show in the report only 011, 012, 013 NOT usa.

Thanks,
 
D

Duane Hookom

I'm not sure what your question has to do with "criteria". If you want to
only display the left 3 characters of a string, you can use the Left()
function:
Left([UnnamedField],3)
 
J

John

Ill try that, When u open up query design view it has the criteria option so
I thought mabey you can add something there.

Duane Hookom said:
I'm not sure what your question has to do with "criteria". If you want to
only display the left 3 characters of a string, you can use the Left()
function:
Left([UnnamedField],3)
--
Duane Hookom
Microsoft Access MVP


John said:
How can I display certain criteria either in the query design or combo box.
For example. I have a list:
011Usa
012Usa
013usa
014usa
015usa

I want to show in the report only 011, 012, 013 NOT usa.

Thanks,
Click to expand...
Click to expand...
 
Top