Formule for Expression Builder

  • Thread starter Thread starter Berry
  • Start date Start date
B

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
 
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
 
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
 
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
 
Back
Top