parameter query

[enigmajl]

i have done a simple parameter query
SELECT.......
WHERE ((([Item].[IPage])="Installed Programs") And (([Item].[IDevice]) Like "*" & [Enter Software:] & "*"));

so if i enter "microsoft" upon prompt it will return all data containing microsoft
and if i enter "microsoft office" the correct data will be returned too.

However I will like to enquire if its possible for me to enter
"microsoft adobe" in the text prompt
and let my data return all fields that contain microsoft, microsoft office and adobe

want to enter more than one keyword at a time, eg do a query like “Microsoft Adobe”

Thanks!!!

 

[Uncle Gizmo]

This is a job for our resident superhero "Mr. Regular expressions" come on Kodo this is definitely a job for your superpowers!

all a joking apart, from what I've read on regular expressions I think it could be the solution you're looking for. I would suggest you google on "regular expressions" and also there are some threads on regular expressions on this site.