You would need a form and then use the On Timer Event on the form to run the
query.
See the help file regarding the On Timer Event of the form. You use the
Timer Interval to set an interval equal to 1 hour using milliseconds.
When the form is opened, the timer runs for x milliseconds and then triggers
the On Timer event which in turn can trigger your macro
HTH
Andre
