Hello,<br>
<br>
I know this may be a simple thing, but the method is escaping me. I have to run a report for our Payroll Clerk at or around noon every weekday. This report calculates pagecounts for the previous day. For now I have the report ask me for the pagecount date. This is ok, but I'd like to automate the whole thing. The intire process is as follows;<br>
<br>
1. Delete old pagefile table.<br>
2. Import pagefile.DBF file from network directory. <br>
3. Run query to select records from previous day. <br>
4. Print Page Count report and turn into Payroll Clerk.<br>
<br>
I've tried setting the criteria in the query using the DateAdd and Date() functions, but keep getting blank results. Any ideas? Unfortunately I won't be able to try them until I get back into work on Monday.<br>
<br>
Thanks. <p>Phil<br><a href=mailto: > </a><br><a href= > </a><br><br>
Most of us go through life not knowing what we want, but <br>
but feeling damned sure that this isn't it.<br>
<br>
I know this may be a simple thing, but the method is escaping me. I have to run a report for our Payroll Clerk at or around noon every weekday. This report calculates pagecounts for the previous day. For now I have the report ask me for the pagecount date. This is ok, but I'd like to automate the whole thing. The intire process is as follows;<br>
<br>
1. Delete old pagefile table.<br>
2. Import pagefile.DBF file from network directory. <br>
3. Run query to select records from previous day. <br>
4. Print Page Count report and turn into Payroll Clerk.<br>
<br>
I've tried setting the criteria in the query using the DateAdd and Date() functions, but keep getting blank results. Any ideas? Unfortunately I won't be able to try them until I get back into work on Monday.<br>
<br>
Thanks. <p>Phil<br><a href=mailto: > </a><br><a href= > </a><br><br>
Most of us go through life not knowing what we want, but <br>
but feeling damned sure that this isn't it.<br>