Anything but zero

[Gojira999]

I have written a query that extracts values from a form and returns a value to a table.

What I want it to do is where the extracted value is greater than zero, to return a value of 1 to the table, else simply return a value of 0.

I have tried using the following field criteria without success:

cbo3: ([forms]![Audit-controlpanel-form]![cbo3]>0) =1 else =0

Please could anyone give me a pointer here.Thanks.

 

[PHV]

Have you tried something like this ?
cbo3: IIf([Forms]![Audit-controlpanel-form]![cbo3]>0, 1, 0)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Gojira999]

Works a treat, thanks .