Basic Query Sort Question

[Siiig]

Sup Access Forums,

I have a query like this...

Field: Item Field: Description
Table: Item_Table Table: Item_Table
Criteria: <>"Do Not Sell"

The above outputs all items who's descriptions are not Do Not Sell. Pretty simple.

What I want to do, is filter out from the item field now, something like this...

Field: Item
Table: Item_Table
Criteria: <>"BR*"



But the above isn't working, and I'm very confused why. Can you not use wild cards to sort queries like this?

[alansidman]

In your criteria try: Not Like "BR" & "*"

Alan

[Siiig]

In your criteria try: Not Like "BR" & "*"

Alan

Worked like a charm!

Would you mind explaining why the <> method worked in one area but not another? I'm quite confused by that.

[alansidman]

In order to use a wildcard in your criteria, you need to use the Like or Not Like functions within Access. The not equal function does not operate with wildcards.

[Siiig]

Thanks so much Alan!

Give a man a fish etc etc.