Previous Month name

[Kimberley]

Hi all,
I'm trying to come up with a query using the Date() function to
determine the month name two months back. Can someone tell me how to
do this?

Thanks for your help.

 

[Gary Walter]

Format(DateAdd("m",-2,Date()),"mmmm")

 

[Kimberley]

Thanks, Gary. That worked perfectly!

Format(DateAdd("m",-2,Date()),"mmmm")