Need help in if condition

[#1]

Hi Friends,

I have a table and the column name is customer_no and the set of values like (10,20,30,40,50,60,70, 80,90,100)

I would like to fetch a value on day basis

If Day(Today() =1 ,

If(WildMatch('10','20','30','40') , 'a1'

          If(WildMatch('50','60','70','80'), 'a2'

                    If(WildMatch('10','20','30','40','50','60','70','80','90','100'),  'a3' as GroupField;

the first and second part is working fine as I need to do work the third part, how do i do that

Please help me...

Regards

Chriss.

[alexandros17]

The field you need (GroupField) cannot contain at the same time value 'a1' and 'a3', to to this you have to add another field.