Searching for " in records

[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

 

[Michael Hopwood]

Use:

WHERE MyField Like "*" & Chr(34) & "*"

In a query

 

[fredg]

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,

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