In a customer enquiry form I have a field with "date order fulfilled". Below this I have three unbound fields that use the DateAdd function to automatically fill a review date 3, 6 and 9 months after the order fufilled date. I have now been asked to create a query and monthly report that show which clients are due for review. But as the data is unbound, I am not sure how to do this.

Any help appreciated.

Just do the same thing in your report -- create calculated fields in either your query or report to create the same time frames ...

It would be even easier to do the calculations in the query and not in the form - that way you can use the query for both the report and the form.

OK, made a start. I have calculated the review dates in the qry. But for the purpose of the report, I effectly need to make the qry a parameter qry, so it only pulls off clients due for review in the coming month. I think I should also show where it is a first, second, or third review. ???? I have given it a go, but it's not working!

OK, made a start. I have calculated the review dates in the qry. But for the purpose of the report, I effectly need to make the qry a parameter qry, so it only pulls off clients due for review in the coming month. I think I should also show where it is a first, second, or third review. ???? I have given it a go, but it's not working!

I was just reviewing some of my posts, and see that there is no resolution posted here -- are you still having problems?

There are a number of ways to "parameterise" your query so you see what you want -- let me know if you still want a hand.