iif statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have this so far
=(Round(Nz([Text1001],0)*Nz([Text651],0),2),Null)
I would like to make this into an IIF satement.
IIF([Date Leave1] is not null then
Round(Nz([Text1001],0)*Nz([Text651],0),2),Null))

can you help me get this to work?
 
or rather
IIF(isnull([Date Leave1])=false ,
Round(Nz([Text1001],0)*Nz([Text651],0),2),Null)

pieter

Ofer Cohen said:
Try

IIF([Date Leave1] is not null ,
Round(Nz([Text1001],0)*Nz([Text651],0),2),Null)

--
Good Luck
BS"D


Chey said:
I have this so far
=(Round(Nz([Text1001],0)*Nz([Text651],0),2),Null)
I would like to make this into an IIF satement.
IIF([Date Leave1] is not null then
Round(Nz([Text1001],0)*Nz([Text651],0),2),Null))

can you help me get this to work?
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Me.Caption In a Form 1
use of not is null 7
Aggregate Function Error 0
#Div/0! Error Message in Access 3
Roundup Function 10
Formula help 7
Adding a CC to email code! 7
#Error while trying to create DateValue in Access 0

Back
Top