Problem: how to make calculated control which calculates "first_day_of_previous_month", based on [today]?

and

"last_day_of_previous_month", based on same pre-entered date?

(On the same form)

thanks!

B.

I use this to convert the entered date to the last day of the month you should be able to play with this to get what you want

Me![End of Month Billing Date] = DateAdd("d", -1, Format("01/" & Format(DateAdd("m", 1, Me![End of Month Billing Date]), "mm/yy"), "dd/mm/yy"))

Take a look at this article in the Microsoft knowledge base (there are several more, you can find by searching).

Q88657 - ACC Functions for Calculating and Displaying Date-Time Values