Need help in if condition

Fri, 05 Jul 2013 14:02:27 GMT

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.

Re: Need help in if condition

alexandros17 — Fri, 05 Jul 2013 14:09:19 GMT

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