How do I filter out records with "." value in Access query?

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

Guest

I importeda text file to Access and want to filter out the records with "."
value. I tried <>"%.%" also <>"." but did not work. Any suggestion? Thank you.
 
yyu1 said:
I importeda text file to Access and want to filter out the records
with "." value. I tried <>"%.%" also <>"." but did not work. Any
suggestion? Thank you.
Click to expand...

In Access/Jet use * instead of % (except in ADO).
 
Back
Top