query on calculated date field

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
You can use a criteria/where clause like:

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