Date Range Expression Problem

[Guest]

I'm desigining a macro so that it will open and print the same report
multiple times. Basically, I want each report to return data with different
date ranges. I'm running into a problem with the "Where Condition" under the
OpenReport Macro Action. The Where Condition I have is:

First Report (showing results of releases between now and the next 12 months)
([qryNewReleases]![Release Date]) = Between Date() And DateAdd("m",12,Date())

Second Report (showing results of releases between now and the next 6 months)
([qryNewReleases]![Release Date]) = Between Date() And DateAdd("m",6,Date())

I keep getting errors that the expressions aren't correct. Could anyone
lend a hand and let me know what I'm doing wrong with the expression?

 

[Ken Snell [MVP]]

Change this expression
([qryNewReleases]![Release Date]) = Between Date() And
DateAdd("m",12,Date())

to this
([qryNewReleases]![Release Date]) Between Date() And
DateAdd("m",12,Date())

Modifying the other expression is an exercise left to the reader for
edification. < g >

 

[Guest]

Ken,

Thanks for the help. I modified the expression and it works perfectly.

- Mkauley

Change this expression
([qryNewReleases]![Release Date]) = Between Date() And
DateAdd("m",12,Date())

to this
([qryNewReleases]![Release Date]) Between Date() And
DateAdd("m",12,Date())

Modifying the other expression is an exercise left to the reader for
edification. < g >

--

Ken Snell
<MS ACCESS MVP>

I'm desigining a macro so that it will open and print the same report
multiple times. Basically, I want each report to return data with
different
date ranges. I'm running into a problem with the "Where Condition" under
the
OpenReport Macro Action. The Where Condition I have is:

First Report (showing results of releases between now and the next 12
months)
([qryNewReleases]![Release Date]) = Between Date() And
DateAdd("m",12,Date())

Second Report (showing results of releases between now and the next 6
months)
([qryNewReleases]![Release Date]) = Between Date() And
DateAdd("m",6,Date())

I keep getting errors that the expressions aren't correct. Could anyone
lend a hand and let me know what I'm doing wrong with the expression?

 

[Ken Snell [MVP]]

You're welcome.

--

Ken Snell
<MS ACCESS MVP>

Ken,

Thanks for the help. I modified the expression and it works perfectly.

- Mkauley

Change this expression
([qryNewReleases]![Release Date]) = Between Date() And
DateAdd("m",12,Date())

to this
([qryNewReleases]![Release Date]) Between Date() And
DateAdd("m",12,Date())

Modifying the other expression is an exercise left to the reader for
edification. < g >

--

Ken Snell
<MS ACCESS MVP>

I'm desigining a macro so that it will open and print the same report
multiple times. Basically, I want each report to return data with
different
date ranges. I'm running into a problem with the "Where Condition"
under
the
OpenReport Macro Action. The Where Condition I have is:

First Report (showing results of releases between now and the next 12
months)
([qryNewReleases]![Release Date]) = Between Date() And
DateAdd("m",12,Date())

Second Report (showing results of releases between now and the next 6
months)
([qryNewReleases]![Release Date]) = Between Date() And
DateAdd("m",6,Date())

I keep getting errors that the expressions aren't correct. Could
anyone
lend a hand and let me know what I'm doing wrong with the expression?