Null

[Tronsliver]

Can someone tell me why this isn't working? Expr1: Switch([ROPAResult]="Null","1",True,[ROPAResult])

I have 200 records and only 115 are showing up in the querie. This is because of "null" entries in the "ROPAResult" field. I tried the above statement with no success. Can someone shed some light on this? Actually there are three possibilities for entries in the field. They are: "J" "1" and "Null".

I don't have permision to change any of the tables' properties.


Thanks

Roger

 

[Cagliostro]

To find null results the correct syntax is
Expr1: Switch([ROPAResult]=is null,.....)
Where you see NULL there is not a string but a value what means there is nothing. John Fill

ivfmd@mail.md

 

[balor]

...or:

IsNull([ROPAResult])

 

[balor]

...John! Remove the "=".
Expr1: Switch([ROPAResult] is null,.....)

 

[Tronsliver]

Balor,

This still didn't work. ROPA:Switch([ROPAResult]Is Null,"1",True,[ROPAResult])

I'm still only getting 115 records out of the 200 because of the null entry?

Thanks

 

[Cagliostro]

My mistake, I did just copy/paste and have forgotten about '='. John Fill

ivfmd@mail.md

 

[balor]

Tronsliver,

Are you sure that this is the problem? Maby there is something else. Maby tou have an inner join to a table where there is no related record for five of the rows? If there is you have to change it to an outer join.

 

[Cagliostro]

I see there in the question only incorrect syntax for searching nulls. I'm a programmer and not a thoughts reader. John Fill

ivfmd@mail.md

 

[Tronsliver]

Balor,

Yep you were right it was a "Join" problem. Thank You!

JohnFil --thanks to you also.