Searching for " in records

  • Thread starter Thread starter Dorothy Bryant
  • Start date Start date
D

Dorothy Bryant

I need to pull out any records that contain " in them, how
do I search for these records. Access will not allow me
to use brackets or wildcard. Any ideas???

Thanks
Dorothy
 
Dorothy said:
I need to pull out any records that contain " in them, how
do I search for these records. Access will not allow me
to use brackets or wildcard. Any ideas???

Thanks
Dorothy
Click to expand...
Dorothy,

WHERE InStr([FieldName],"""")>"0"
 
Back
Top