Hi all,

Finally i was able to fix this

Sorry for posting this in a incorrect thread.

However I was able to solve it through using IIF function in access

Thanks again

Asela

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...

thanks you all for your prompt response. I'm so grateful for you all for spending your valuable time on assisting people like us.

let me clear my requirement as follows. I'm...