Hi there,
I have a really simple question.
I have a field in a table that contains comments (text format). I want to run a query where I can get only the records that contain the word "high" in the comments. There may be some typos so I would like records returned that also contain something like "high". High is not the only word in the comments.

Does this make sense?

Thanks,
Row

In query Criteria use Like *high*

rowk,

I hate trying to explain query grids.

In your query, on the Criteria Line, for your comments field put:

Like "*high*"

Then underneath that entry, put:

Like "*hih*"

And so on.

By putting them on separate lines vertically, that makes an OR condition.
If the field matches any of them, the record is returned in the query.

Wayne

worked like a charm - thanks for your help!!

Rowk,

Thank you.

Welcome to the Forum.

Wayne