Hi,

thank you all for the responses given on this

however I came to know that ACCESS SQL doesn't support case when statements. is that correct?

further, during past few days I was looking for many options and found that IIF function too can be used to handle this sort of situation.

for instance;

select Year, Month,iif(ComboboxA = 'FT1',FaultType1,iif(ComboboxA = 'FT2',FaultType2,FaultType3)) as FaultType from Table1.

however each time when i make selection in my ComboboxA Combo Box and refresh the related table it asks to enter parameter value this Combo Box.

(I have attached the error message with this)

Any idea on why it asks to enter such parameter?

I f I can overcome this issue I guess my work is done

anyway thanks for the help on this 🙂