search two fields with one query

[Weresmytriple]

hi im using the quesy criteria "Like "*" & [Please Enter the subject (Or part of it)] & "*""

I was just wondering if there is any way to set this up so that the one prompt box searches 2 different feilds

 

[pr2-eugin]

Use the same criteria in the other column !

 

[Weresmytriple]

i only what the user to enter the criteria once and not have to enter it twice into the 2 different promtp boxes

 

[pr2-eugin]

Show the SQL of the Query !

 

[Weresmytriple]

SELECT [Clinical Guidance].Name, [Clinical Guidance].Folder, [Clinical Guidance].Location
FROM [Clinical Guidance]
WHERE ((([Clinical Guidance].Name) Like "*" & [Please Enter the subject (Or part of it)] & "*"));

 

[pr2-eugin]

SELECT Websites.[Website Link], Websites.Categories, Websites.Votes, Websites.Total, Websites.Hits
FROM Websites
WHERE (((Websites.Categories) Like "*" & [Please Enter the website (If Known)] & "*") 
[COLOR=Red][B]OR ((Websites.[Website Link]) Like "*" & [Please Enter the website (If Known)] & "*")[/B][/COLOR])
ORDER BY Websites.Hits DESC;