Date format - same day one month ago

[Wayne Cramer]

I need to enter a date field into an appended table that is the same day but one month prior.
For example today is 6/5/2008 and if I ran the query I want the date to appear as 5/5/2008.
Thanks for any help on this.

 

[Brianwarnock]

Can you not use DateAdd with minus 1 month?

Brian

 

[Wayne Cramer]

Brian. That's exactly what I needed. Thanks!