Display certain criteria.

[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,

 

[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)

 

[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.

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

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,