how to run an append query at a specific time of day RRS feed

  • Question

  • I want to "rollover" yesterday's end-of-day inventory totals to the beginning inventory figures for the current day. The totals are available after midnight so I'd like to run at 01:00 on the current day.  I've looked at Event Criteria in a form but don't see a way to specify the time to run an append query to do the rollover.  would appreciate any suggestions.
    Monday, September 19, 2016 9:25 AM


All replies