Using a query to fid records with Question Marks (1 Viewer)

[RHubbard]

I need to identfy records that have Question Marks imbedded in them. I can't figure out how to do this with a query (although I can find them using Windows "find".
Any ideas would be appreciated.

Thanks,


Rick

 

[Gootz11]

Put a question mark on the criteria of the column where the question mark is found. it will return all records that have question marks.
you can also try the ?***** funtion in the criteria

 

[RHubbard]

Yeah, that what I tried to do.

When I do that, however, the question mark is replaced with [?], then when i try to run the query, a parmaeter box opens. If I put a question mark in the parameter box, it returns no records (which I know is incorrect).

This whole thing is made a little more complicated by the fact that there can so me time be SEVERAL question marks in a paricular record like this ???????

I'm baffled

Rick

 

[RHubbard]

Hmmmm. I guess I answered my own question. For anyone else who cares, here's what to do:

Like "*[?]*"

Works Fine.

Tahnks

Rick