multiple cases

[zhuanyi]

Hello,
Say for example, I would like to run a query that would search through a table with each person's deposit amount, assign band 1 if they have deposit less than 1 million, band 2 if 1-2 million and band 3 if more than 2 million. How can I:
1. Add in the extra column in the table?
2. Assign the bands since I can not use iif here as their are 3 cases?

Thanks!

Regards,
anyi

 

[KeithG]

You can use the Switch function