dates isnull

[steve111]

hi ,

I have a form which has parts that needs to be purchased ( could be 100 different parts)
on each part there is a date field , which allows me to say when I want each part delivered (date reqd). I also have created an date field ( date required) that allows me to put one date in and that date could be used when the parts are required on the same date

I tried to create a formula is my query that says
iif( date reqd)="", date required, date reqd) but that don't work ,

any help appreciated

steve

 

[pr2-eugin]

So what is the difference between "date required" and "date reqd" other than the very obvious spelling? Could you give another shot in explaining the situation?

 

[JHB]

Maybe the below code would work, else show some sample data.

IIF(IsNull([Date reqd]), [Date required], [Date reqd])

 

[diberlee]

I think you would need something more like this

iif(nz([date reqd],"")="", date required, date reqd)

Nz function returns the value after the comma if it finds a null value, null is not the same as ""

 

[vbaInet]

If JHB and diberlee are reading your situation right, then all you need is:

Nz([Date reqd], [Date required])

 

[steve111]

thank you all for help the one that worked was

Nz([Date reqd], [Date required])

again thank you all

steve