InvoiceDueDate: DateAdd("d", [Terms], [Expected Date])
but the System Notes isn't working?

Sorry - InvoiceDueDate: DateAdd("d", [Terms], [Expected Date])WORKS

but:System Notes isn't working

The DateAdd should work, this is good advice.
His comments assume that [Terms] is a Variable for Each Record.
Therefore, this explains why you got #Name before, probably.
You can just use 30 in the [Terms]
If [Terms] is a field, then is it an integer.

Is this on a Form or A Report.
If on a Form, did you use =IIF( ) in the Control Source?

N.B. Its always good idea to not name your fields with spaces, and include the field type in the name of the table field.

Database Agreements

What exactly is System Notes giving you?

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

It shows a error message “#Error” and then after I enter the Terms, the “#Error” disapers and just showed a blank field.
I changed the formula you gave me to: =IIf(Date()>[InvoiceDueDate],"Past Due","Not Past Due")

And now it works but still shows the “#Error” in System Notes & Due Date prior to entering the Terms. Is there a way it can just be blank?

What do you mean by "entering the terms"? Do you mean that there is no field in the table called "Terms" and that the query is prompting you to enter it on the fly?

If so, that is the problem. The function cannot work without a value for "Terms". You need a field for "Terms" in your table filled with values ahead of time.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Can I e-mail you a sample of the data?

Corey why not try someting like this

=IIf(Me.Terms.Value=Null,"Terms not set",IIF(Date()>[InvoiceDueDate],"Past Due","Not Past Due"))