Performing query on unbound data

[Bentleybelle]

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.

 

[databasedonr]

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

 

[Mile-O]

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.

 

[Bentleybelle]

A bit further on in the qry

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!

 

[Bentleybelle]

A bit further on in the query

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!

 

[databasedonr]

Still a problem?

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.