Access Help Please

[Ross]

Hi,

Can anyone help me, I need to have a form with a text box which is to be used as a search key. However the search key could exist in upto 4 fields in the table. I need the results to display all 4 fields if the key exists in any one of them?

Does that make sense?

Thanks a lot.

Ross

 

[GravyMonster]

SELECT Field1, Field2, Field3, Field4 FROM Table WHERE (Field1 LIKE '%SearchString%') OR (Field2 LIKE '%SearchString%') OR (Field3 LIKE '%SearchString%') OR (Field4 LIKE '%SearchString%');

HTH!