Showing Date Criteria On Report

[dan.cawthorne]

Thanks to steve who gave me the criteria for my query which enable my
report to Automatically Filter projects that that week,

what i would like to also do is have a unbound text box which display
these date how do i do this?

This is the Criteria i used Between "DateAdd("d",-4,Date()) And
Date()" Under ReciveciedDate field.

cant i just use something like this on my report

=Between &DateAdd("d",-4,Date()) And Date()

 

[Douglas J. Steele]

="Between " & DateAdd("d",-4,Date()) & " And " & Date()

 

[dan.cawthorne]

="Between " & DateAdd("d",-4,Date()) & " And " & Date()

Your a Star Mate, I know its was something like that Just couldn't get
the " and the ' and the & in the right order

is there some how or way i can use to help me remember?

 

[Douglas J. Steele]

You just have to remember that every time you want a literal text string,
you have to put quotes around it, and every time you want the value from a
variable or calculation included, you have to concatenate the value using &.