Hi, I use Access 2007, and I get an error message when I try to enter these codes in the AccountReceivableAgeQ:

Current:IIf([DueDate]>=Date(), [OrderTotal],0)

LessThan30:IIf([DueDate]=Date()-30,[OrderTotal],0)

LessThan60 :IIf([DueDate]=Date()-60,[OrderTotal],0)

MoreThan60:IIf([DueDate]
The error message says that the expression is not valid. That I am trying to enter an operation without an operateur.... (I have a french version of Access, so I think it is what it's written....)

---

Reply from Richard Rost:

I can tell you that if you type in the expressions EXACTLY as they're shown in the video, they will work just fine with Access 2007. I've tested this with 2003, 2007, and 2010.

I can see from your copy/paste that you did type in LessThan30 and LessThan60 wrong. You've got just = in there and not <=. Although that wouldn't generate an error as it's written, it's incorrect, so it leads me to suspect you've got something else typed in wrong too.

Not sure if your language has anything to do with it. I've never used any of the foreign-language versions of Access, but I doubt that's the problem.