Using Conditionals in Query

[oz]

Hi people!

I have to use conditional sentences within the queries but no use. Should I try the modules or what do you recommend me? If I can solve this problem everything would sure be clear.Need urgent Help!

Regards,
Ozz

 

[Dreamboat]

Give us some examples of the kinds of conditions, oz.

 

[glynch]

You can use an immediate IF statement in your query. Usually they are used in the criteria line but can be used with the field name as well. Typical usage:

Iif(formABC!fieldABC > 10, True, False)

It is an If,Then, Else statement all in one expression, the commas separate the parts of the experession.

Iif(IF this statement is true, THEN this field has this value, ELSE it has this value)

Hope this helps.

 

[oz]

Dear Glynch,

You're great. It works.