Combining Values

[Gojira999]

Hello again generous friends!

I am building a query that extracts the values from two fields on a form and, dependent of the values, allocates a value to a table field.

I have tried using the following as my field in the query:

value3:if (value1=0 and value2 =0) then value3=0 else value3=1

but I get a syntax error.

Is this the right way to approach this or am I missing something?

Thanks.

 

[KenReay]

Hi

value3:iif ((value1=0 and value2 =0),0,1)

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[PHV]

Another way:
value3: Abs(value1<>0 Or value2<>0)

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

 

[r937]

phv, that may work but it's far too obscure

one of the objectives of creating sql solutions is that you should be able to understand them

no star for you, sorry



rudy

http://r937.com/

SQL Consulting

 

[Gojira999]

Both appear to work!

Thanks both!