Automate query results
Bob,
Is there is anyway I can automate this query to run everyday and place output file in a network drive ??
Just open tblCDCCodes.
Add a new record: CDC 99; Remarks: "No entries" (minus the quotes).
Then run AddDate(). Anytime you add new records to tblCDC, you'll need to call this sub to ensure that you've accounted for dates without entries. Don't worry, it'll only add one dummy record for any given date.
Bob
Bob,
Is there is anyway I can automate this query to run everyday and place output file in a network drive ??