Alternsti
01-26-2022, 11:23 AM
I'm able to connect and retreive data using the SQL string below BUT it seems the WHERE isn't working properly. hdr_RD section
http://icons.iconarchive.com/icons/double-j-design/ravenna-3d/24/File-Copy-icon.png
SQL = "SELECT [hdr11], [hdr31], [hdr32], [hdr33], [hdr34] FROM " & strTable & " WHERE [hdr_RD] Like 'New' OR [hdr_RD] Like 'Hold' AND [nhr_ISD_by] Like 'ES-8000-00' AND [ndr_TP] Like 'FV' OR [ndr_TP] = 'LV' OR [ndr_TP] = 'PV' OR [ndr_TP] = 'TV'"
Look like a typo error or something missing?
http://icons.iconarchive.com/icons/double-j-design/ravenna-3d/24/File-Copy-icon.png
SQL = "SELECT [hdr11], [hdr31], [hdr32], [hdr33], [hdr34] FROM " & strTable & " WHERE [hdr_RD] Like 'New' OR [hdr_RD] Like 'Hold' AND [nhr_ISD_by] Like 'ES-8000-00' AND [ndr_TP] Like 'FV' OR [ndr_TP] = 'LV' OR [ndr_TP] = 'PV' OR [ndr_TP] = 'TV'"
Look like a typo error or something missing?