I have dataset, the user wants the option to filter by three option. ColorType, ColorStatus, ColorLocation. Color Type has it dropdownbox values,
ColorStatus has it own dropdownbox value, and also ColorLocation has dropdownbox values relating to the dataset. Can you help me figure out the correct
where clause for the three filters below. all the value are strings, so you can make up any value now
| ColorType: |
ColorStatus: |
ColorLocation: |
| select type |
select status |
select location |
Select ColorID, ColorType, ColorNotes, ColorStatus
From Color Table
Where ????