Showing certain criteria in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm having a problem getting my query to show certain criteria. I first made
a query and i didn't want it to show certain criteria and all i did was type
in NOT LIKE"APPLES" and it worked. But now i need the query to only show
Apples. So i went and typed in LIKE"Apples" and it is not working. There is
like a lot of critera and i don't want to type in NOT LIKE"ORANGES" and not
like "PEARS" and etc....for all the different types. What can i do to only
make the Apples show up in the field?

Thanks Crisyina
 
Crisyina said:
I'm having a problem getting my query to show certain criteria. I first made
a query and i didn't want it to show certain criteria and all i did was type
in NOT LIKE"APPLES" and it worked. But now i need the query to only show
Apples. So i went and typed in LIKE"Apples" and it is not working. There is
like a lot of critera and i don't want to type in NOT LIKE"ORANGES" and not
like "PEARS" and etc....for all the different types. What can i do to only
make the Apples show up in the field?

Thanks Crisyina
Click to expand...

Hi Crisyina. You can look at this web site for more info:
http://office.microsoft.com/trainin...ID=RP011269241033&CTT=6&Origin=RC011269441033

I would just type "Apples" like the example. The next page describes
more
about types or criteria.

http://office.microsoft.com/trainin...ID=RP011269221033&CTT=6&Origin=RP011269241033
 
LIKE is misunderstood and over used.
Instead of NOT LIKE "APPLES" use <> "APPLES"
To get Only Apples use "APPLES"
If you wanted Apples, Pears, and Grapes,
IN("APPLES", "PEARS", "GRAPES")

LIKE is realy intended for when you want to use wildcards. For example,
lets say your field could have APPLES1, APPLES2, APPLES3, ORANGES1, PEARS1,
PEARS2, etc. You would use LIKE "APPLES?" to get everything that start with
APPLES
 
Back
Top