N
Noozer
The following SQL query demonstrates what I'm trying to do (but it doesn't
work - I get no rows)...
SELECT Code, IF(HardwareFL,"Hardware ", " ") + IF(SoftwareFL,"Software ", "
") + IF(OEMFL, "OEM ", "Retail ") AS Style, Price ORDER BY Code;
....Basically I have a number of boolean columns in my table. I want the
query to generate a single string based on some of those booleans.
I'm trying to do this in an MS Access databse. This query will be the row
source for a listbox on an Access form.
work - I get no rows)...
SELECT Code, IF(HardwareFL,"Hardware ", " ") + IF(SoftwareFL,"Software ", "
") + IF(OEMFL, "OEM ", "Retail ") AS Style, Price ORDER BY Code;
....Basically I have a number of boolean columns in my table. I want the
query to generate a single string based on some of those booleans.
I'm trying to do this in an MS Access databse. This query will be the row
source for a listbox on an Access form.