Is there a way to filter using the # character in Access?

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

Guest

I am trying to filter out all of the data with a # in the field on a form or
in a query. Is there a way to tell Access that I am looking for the
character not a date field?
 
The problem here is not that Access is interpreting the # character as a
date delimiter, but as a wildcard. To tell Access to treat the character as
a literal, enclose it in square brackets ...

SELECT tblTest.*
FROM tblTest
WHERE (((tblTest.TestText) Like "*[#]*"));
 
Sound like you put dates in a text field. If want not to pull records with
the # character in the field here is one way to do it.

Make a query with criteria for the field -- Not Like "*"&"#"&"*"
 
Back
Top