A accesscrzy Aug 4, 2004 #1 I want to ask the user to input one keyword and search two different fields in the same table. Any suggestions?
I want to ask the user to input one keyword and search two different fields in the same table. Any suggestions?
M MGFoster Aug 4, 2004 #2 PARAMETERS [Keyword?] AS Text; SELECT * FROM Table_Name WHERE Column1 = [Keyword?] OR Column2 = [Keyword?]
PARAMETERS [Keyword?] AS Text; SELECT * FROM Table_Name WHERE Column1 = [Keyword?] OR Column2 = [Keyword?]
