query with multiple criteria prompts

[Guest]

When I run a query, I need to be prompted to enter 2 different strings.

The field is 'Status' and I need to have it return all data containing 2
different strings. For example, records where 'status' contains "Microsoft"
and "6".

Any suggestions?

Thanks

 

[John Vinson]

When I run a query, I need to be prompted to enter 2 different strings.

The field is 'Status' and I need to have it return all data containing 2
different strings. For example, records where 'status' contains "Microsoft"
and "6".

Any suggestions?

Thanks

A criterion of

[STATUS] LIKE "*" & [Enter first string:] & "*" AND [STATUS] LIKE "*"
& [Enter second string:] & "*"

will work. Why does your Status field apparently violate atomicity by
containing both numbers and text, which are evidently separately
searchable? Might you not do better to have two fields?

John W. Vinson[MVP]