The report I am working on is a lease agreement. If a person moves in on a date after the first of the month, then the lease actually starts the first of the next month. The partial month that the person moved in on is pro-rated. The persons rent is the full amount the first of the next month.

I would like to have a simple IIf statement that says:

If $515 is less than $600 then 07/01/2003, if not then 06/01/2003

IIF([ProRatedDays]<[RentalRate],???????????,[LeaseStartingDate])


In the form that I use I manually enter a MoveInDate and a LeaseStartingDate so I could possibly use a MoveInDate instead of my ProRatedDays and RentalRate.

IIF([MoveInDate]<[LeaseStartingDate],?????????,[LeaseStartingDate])

The ??????'s need to reference the 1st of the next month, I can get the last of the month, the days between, the end of the lease etc.

Does anybody have an idea on how to do this?

Thanks for your help and suggestions

Have a look at Various Date manipulation functions (http://www.mvps.org/access/datetime/date0007.htm)

Hey, Thanks for yyour help Nouba!

I'll see if I can get one of these to work for me.

Thanks again

Peanuts