IIF Between Expression in Access 2003

[kwilliams5675]

I have written the following expression to label data between a certain range and I am getting errors. Can someone identify what I am doing wrong.

Type: IIf([Table_Name]![Field_Name] >=500 & <=599,'Member', IIf([Table_name]![Field_Name] >=200 & <=299, 'Agent'))

Any help is greatly appreciated.

[Rhino373]

IIf([test].[alpha]>=500 And [test].[alpha]<=599,"Member",IIf([test].[alpha]>=200 And [test].[alpha]<=299,"Agent",[test].[alpha]))

Turn your exclamation points into periods and change your ampersands into AND

[kwilliams5675]

Thanks Rhino! Worked great!