Iff Statement

[smc678]

I have a query with [Date] and [Ending Date] I have another column with =[Ending Date]-[Date] to get the total difference. What Im trying to get is if the [Ending Date] is null then it will return the [Date]? So if someone forgets to put in the ending date it will return the date.

[pbaldy]

Check out the Nz() function.

[smc678]

didnt work!

[ssanfu]

What was the error message?
What happened?

What is the SQL of your query?

Your problem would get solved sooner if you provided more info sooner.