Query iif

[krzysiekk]

How build function iif when i had querys:

query_report
product, price, invoice date - its report query

query_info
product, price, invoice date

query_extra
product, price, invoice date

I want build function iif - query_report should be checking product in query_info if is true should show price but no invoice date, if false should be check query_extra if true should show price and invoice date if false left blank field.

It is possible ? please help

 

[llkhoutx]

I tells my clients when they ask if something is possible, the answer is always "Yes."

If you can articulate it, you can build the conditional "iif."

 

[krzysiekk]

how start please schow me example

 

[jdraw]

how start please schow me example

We do not understand what you are trying to do.

Please provide simple example to help us understand.

 

[krzysiekk]

I traying build func. iif

IIf(IsNull([query_info.product]),[query_info.product],[query_extra.product])

but not working

 

[jdraw]

I traying build func. iif

IIf(IsNull([query_info.product]),[query_info.product],[query_extra.product])

but not working

Iif is a built in Access function.

This may be helpful. http://www.youtube.com/watch?v=kL5t70j-USw