I?ve been learning SQL expressions on the fly for months for Access 2007 and trying to find a decent course to learn it so I don?t? have to bother you folks but for now I still have to.
Right now the person that I?ve been doing this for wants one of the fields to have more than a simple DateDiff calculation. Below I?ve written two versions of what he wants but I don?t know how to go from the IIF statements to the DateDiff statement. I?ve tried a huge number of iterations to attempt to do this:
=IIF([ToDate]>0,IIF([FromDate]<0 THEN =DateDiff(?d?,[ToDate],Now()))
Or in English, it?s:
IF the ToDate is not null and the FromDate is null then calculate the number of days between the ToDate and Today.
I hope I?m making myself clear. Thanks for any help you can send my way!