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

Y

yyu1

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.
 
R

Rick Brandt

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).
 
Top