Conditional Where clause using SQL in Access

[Jinzuku]

Hi all,

Here is my situation. I've got 3 combo boxes that are used to filter data from my main database. These are Organisation Name, Contract Type and Branch Name.

Under normal circumstances that's easy to do, however there is another constraint. There are 3 contract types, 1 of them (Type A) requires all 3 fields to be populated and searched upon. However if it's any of the other 2 (Type B and C) then it must search based on just Organisation Name and Contract Type. The way I've thought of doing this is using some kind of conditional where clause but I'm not sure how to go about writing the script.

I thought about a case clause but I don't think it's supposed to used in that way.

I know I'm supposed to put some kind of attempt at the code but none of the coding I've used so far even comes close to making sense.

Any help you lovely people can offer will be great

Thanks

Sunny

[Rabbit]

Filter the name and type normally. For branch, use the IIf() function to check the contract type, if it's type A, return the value to filter on, otherwise return the branch.