Query search multiple fields in a textbox

[deanvilar]

Need your help once again guys ...

I have 4 serial description and 4 serial number fields, if I search for 1 serial description and 1 serial number it's not a problem .. but i cant figure out how to search for the 4 fields and find 1 value for serial description and 1 value for serial number in a textbox ... please find my codes below ..

strquery = "SELECT * FROM mainTableAsset WHERE serialDesc1 =  '" & Me.cmbSearchSerialDesc & "' and serialNo1 ='" & Me.txtSearchSerialNo & "'"

[Rabbit]

You should normalize your data. It will make querying easier.

For more on normalization, read this article: http://bytes.com/topic/access/insigh...ble-structures

[deanvilar]

let me check on that sir thank you.