ADDING DATE RANGE TO A LABEL

[HerickP]

Hi, <br><br>I have a report based on a query and this query is run based on a date Range I specify. Here is the criteria I use for one of the fields, which is a date field:<br><br>&quot;Between [Enter Week Start:] And [Enter Week End:]&quot;<br><br>When I run the query, it will ask me for the first and then a second date ( which is the date range this query will run). I have a command button in a form which will trigger a printreport, and since this report is based on that query, it will first ask for these two dates , and then print. but in my report design, I have a label in the Report Header, and everytime I want to run the report, I want the label to look like: &quot;ASNs from &quot;MM/DD/YY to MM/DD/YY&quot;, where these two dates have to be the dates I specified in the query code (&quot;Between [Enter Week Start:] And [Enter Week End:]&quot. How do I code the label to do this???? Thanks!

 

[famousb]

don't use a label, use an unbound text box, with control source of<br><br><b><br>=&quot;ASNs from &quot; & [Enter Start Date] & &quot; to &quot; & [Enter End Date]<br></b><br><br>this should do the trick for you <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>

 

[HerickP]

THANKS!!!!