Date Calculation

[logle0917]

I don't know how to do this but I have an Effective date that I have to calculate to show me all data that begins 30 days before this date and then 90 days after how do I write this in MS Access 2007? Please help!

[JoeM]

If you mean in a query, then you can simply add this criteria to the field with the dates (adjusting the field name accordiningly):
Between [Effective_Date]-30 And [Effective_Date]+90

[logle0917]

Thank you Joel I left some out though I have the data that comes from 08/2011 to present now on a monthly basis I have to calculate a report that says for this month based on the Effective Date example the month of June but 30 days before the Effective Date in June and 90 days after the Effective date in June That will show me how many forms were done within the alloted time frame. So not sure how to do that.

[JoeM]

I am not sure I understand your last comment is any different from your original question, and why it wouldn't work.
Perhaps if you take us through a realistic example (with sample data), it will become more clear.