using iif with an aggregate function
Hi,
Thank You for your replies. I had tried with count. this works fine but there is one problem with using count
Eg:
if my table has the following values:
Name Age Place Dept
aaaa 23 Mumbai Accounting
ccc 50 Delhi Finance
fff 20 Delhi Accounting
hhh 10...