If statement

[Pomna]

Hello everyone,

I need to create a table to show customer satisfaction rating on a daily basis that is not null(or -) and less than 5. I already created the table but it shows ratings that are null and some that have a rating > 4. Thanks for your suggestions.

[Tanalex]

Check out Not IsNull(FieldName)

[Pomna]

Thanks   Marmentrous5  but it does not work

[Saravanan_Desingh]

Can u try like.

Not IsNull([Customer Rating]) And Trim([Customer Rating])<>'' And Len([Customer Rating])>0 And [Customer Rating]<5

[Pomna]

Thanks but I get only zeros. Not what am looking for. Below is the set expression I used

=Not IsNull([CusSat Rating])<>'' And Len([CusSat Rating])>0 And [CusSat Rating]<5

[Saravanan_Desingh]

=Not IsNull([CusSat Rating])<>'' And Len([CusSat Rating])>0 And [CusSat Rating]<5

The above is wrong. May be..

=Not IsNull([CusSat Rating]) And Len([CusSat Rating])>0 And [CusSat Rating]<5