Date Range Report

[ali3n8]

I have tried entering the formula in the criteria field for the query also, is this what you were speaking of?

[mlcampeau]

I have tried entering the formula in the criteria field for the query also, is this what you were speaking of?

No, what I meant was, in design view of your query, in the Field row of an empty column, type something like:

FollowupDate: DateAdd("m",3,[OrderEntered])

Then on your report, in the field list, you should see FollowupDate and then add that field on your report instead.

[ali3n8]

Thank you I tried your method and it does work to the extent that it shows the follow up date on my report Im just still not able to pull a report via date range Ive entered this into the critera row for FollowupDate to >=[forms]![frmReport]![txtDateFromfoll owupdate] And <=[forms]![frmReport]![txtDateTofollow update] I am using a form to enter my date ranges. Unfourtunately I have still been unsucessful in achieve a date range for this paticular report.

[ali3n8]

Actually it did work im just a dee dee and had mispelled somethings in my code. Thank you much I appreciate it.

[mlcampeau]

Actually it did work im just a dee dee and had mispelled somethings in my code. Thank you much I appreciate it.

I'm glad you got it to work! Good luck with the rest of your project!