Search Query

[convey2web]

So I have a basic query question.. Is it possible to perform a search across multiple fields with one search parameter? Meaning let say I have two fields that I want to search... Owner and user. And I want to list all owners and users that contain the letters "Sm"... How would I do this?




Thanks

[ajetrumpet]

where owner like "*" & "sm" & "*" 

or user like "*" & "sm" & "*"

for many fields, you'll need code to loop the dataset. writing them manually would be impractical.

[convey2web]

Where would I put this code?

[ajetrumpet]

in the criteria section of the query:

select whatever from table

where [CODE HERE]