Search multiple fields in one table

[BWGreen]

Hi,



I'm not sure if this is the right section for this - if not, feel free to move it to where it should be!

I have a database of items with multiple fields for the name of each record. These names are not unique. I want to be able to search several fields on a specific item; for example, assume the database has field_a, field_b, field_c, & field_d - if any of those match show the record.

Can this be done? And how do I do it? I know it can be done with "pure" SQL but the powers that be here want to use Access.

Thanks,

Brian

[ranman256]

Make many queries but each query searches only 1 field...like qsFld1, qsFld2, etc
qsFld1.sql = select * from tbl where field_a = '" & forms!frmMain!txtBox & "'"
qsFld2.sql = select * from tbl where field_B = '" & forms!frmMain!txtBox & "'"

all queries would read the search value from a form.

Make a macro could then open all (X) queries at once.