Formule for Expression Builder

[Berry]

Hi,

Who can help me with the following problem
I've a datafile contain values as H1101AKN, I1101AKN, I1101MZN,
I1102AKN, I1161AKN etc.

Try to make a formulie for expression builder which doesn't show the
cells contain the value I110.
So in above example only the first and last cell will show in the
database.

If you need any more specs, please let me know!

Best regards,
BL

 

[John Spencer]

Use a where clause to filter the records.

To eliminate records where the field STARTS with I110
Field: SomeField
Criteria: NOT LIKE "I110*"

If you want to eliminate records where the field CONTAINS I110
Field: SomeField
Criteria: NOT LIKE "*I110*"


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[Berry]

Thanks a lot John,
I'm a beginner with Access and learning every day.

If I also want to eliminate records with I1110 and I1111 and I1112, is
it possible to fill in criteria:
Criteria: NOT LIKE "*I110* or I1110* or I1111* or I1112*"

Thanks again!!

Regards,
BL

 

[John Spencer]

In that case you can use
Criteria: NOT (LIKE "I110*" OR Like or "I1110*" or Like "I1111*" or Like
"I1112*")

Alternative would be to use
Criteria: Not Like "I110*" and Not Like "I111[012]*"

Look up WildCards in the HELP to see an explanation.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County