View Single Post
 
Old November 7th, 2005, 05:34 PM
SerranoG SerranoG is offline
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

Make these two changes.

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

System Notes: IIf(Date() > [InvoiceDueDate], "Past Due", Null)


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