I need a criteria expression to not include records that start wit

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

Guest

I have a list with some records that start with *. I would like to exclude
these from the list with a query. I have tried Not Like '~*%' but it does
not exclude the records. Does anyone have a suggestion for me.
 
Hi Steve

use an auxiliar column with this formula

=if(lefet(a2,1)="*",mid(a2,2,255),a2)
hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Steve A" escreveu:
 
Thanks for your help but I am trying to accomplish this with query so I don't
have to manipulate the table each time I re run the query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exclude records that start with * 3
Access Dcount (multiple criteria) 3
VBA: How can I use a string variable as autofilter criteria? 4
Dsum Help 0
help returning the same values from two different cells 1
Query criteria - exclude data and return all records if null 3
underscore sign in query 5
Criteria not excluding data 2

Back
Top