microsoft.public.access

On Thu, 18 Oct 2007 10:51:02 -0700, Candy
wrote:

>This was very helpful, and yes, I did want to calculate it on EffectiveDate.
>However, for those with a date past the 15th of the month, it calculated the
>FirstDue correctly, but the 2nd date jumps to 12/1/07, it didn't matter which
>month it was, and then all the 3rd Due says 12/31/07. But this does help
>alot. Thanks

Are you using something like

FirstDue: IIF(Day([EffectiveDate]) <= 15, [EffectiveDate],
DateSerial(Year([EffectiveDate]),
Month([EffectiveDate]) + 1, 1)

and similarly for the others? If so and it's still not working, please post
the code you're actually using.

John W. Vinson [MVP]