Recoding tables! 1

[Gaylord]

Hi,

I was wondering if anyone know how to do this....

I run a query to generate a new table, where if there is a null value, then a value of '0' is output is a processed data column using this command in the query designer

First_Ob_Output: IIf(IsNull([First_Ob_Pulse]),"0",[First_Ob_Pulse])

But, what I also then need to do, is if the value is not null, output a value of 1.

Basically this is for a clinical audit, where the value isn't important, though having performed the test is... so I only need a positive/negative result!

Hope someone can help me!

Best regards

Jamie

 

[Gaylord]

I am so stupid sometimes

First_Ob_Output: IIf(IsNull([First_Ob_Pulse]),"0",[First_Ob_Pulse])

change this to..

First_Ob_Output: IIf(IsNull([First_Ob_Pulse]),"0","1&quot

Oh well, learn something new each and every day!

Cheers

Jamie

 

[lespaul]

Have a star for figuring it out yourself!! We all have those days!

leslie