Iif In Query

[mithani]

Hi Freinds,

Can anyone please tell me that how can I use IIF function in my query?

Thanks

mithani

 

[boblarson]

Depends on what you need to do. You can use an IIF to return a value based on another value, or you can use an IIF as criteria for the query. Which are you trying to do?

 

[mithani]

Hi Freinds,

Can anyone please tell me that how can I use IIF function in my query?

Thanks

mithani

 

[KeithG]

What do you want to do with the IIF function?

 

[mithani]

Hi,

To make it more clear, I would like to use this code:

IIF([calculation]<>0,(totalpurchase: [tblInvoiceChild].[quantity]*[tblInvoiceChild].[unitrate]),0)

but not working.

Any help

mithani

 

[boblarson]

IIF([calculation]<>0,(totalpurchase: [tblInvoiceChild].[quantity]*[tblInvoiceChild].[unitrate]),0)

You got it slightly mixed up -

totalpurchase:IIF([calculation]<>0,[tblInvoiceChild].[quantity]*[tblInvoiceChild].[unitrate],0)