AUTOMATIC DATE DATE GENERATION FOR REPORTS 1

[HerickP]

Hi,<br><br><br>Thanks to many of u here, my project is going smoothly, except for some little things i could not get to work...<br><br>For Instance, by creating a query and then have a report printed for that query, i can find total of delivered Pos by a specific date range. But, my boss has asked for weekly reports, so is there a way u can instruc a query to have a report printed weekly?? Let me explain: Today is Friday, 19th, end of the week; If I run my report to print, It would show stuff that was delivered only this weeks date range ( from 05/15 to 05/19 ), but the query would know this date stamp, instead of having me to enter???? Can it be done??? Tahnks again!!

 

[famousb]

sure, instead of having the criteria for the date in the query of <b>Between [Date1] AND [Date2]</b><br>try<br><b><br>Between Date() And (Date()-5)<br></b><br><br>and then just run it every friday (which you could also probably automate if you wanted to get that complex - if you really want to impress your boss, have it automatically print to his printer) <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>

 

[HerickP]

Cool!!!!! hey, U know when u generate the report, Access creates the Report Heading ( a label); Is there a code that generates like, a &quot;automatic&quot; heading like &quot; Totals for This Week 05/15/00 to 05/19/00&quot; ????? hope not asking too much!!

 

[famousb]

instead of a label for a heading, use an unbound text-box and have the same type expression.<br>ie.<br><b>=&quot;Totals for Week &quot; & (Date()-5) & &quot; to &quot; & Date()</b><br><br>this should work for you. <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>