query on calculated date field

[Guest]

I have calculated date field in my query:
Target Closure Date: [Date Report Issued]+45

the problem is when i try to filter particular date range in the Target
Closure Date field (ex: between 8/21/2006 and 8/31/2006) it doesn't work. Now
the query is asking for paramater value for Target Closure date and i don't
have it set up as a paramter.

 

[Duane Hookom]

You can use a criteria/where clause like:

WHERE [Date Report Issued]+45 Between #8/21/2006# and #8/31/2006#