rpangel,
Just enter your queries in the macro in the order you want them run. e.g. openquery 1, openquery 2, etc, then openreport yourreportname, then quit as the last line.
You can either use AT or the task scheduler that comes in the IE4 desktop update for NT and is much easier to use. Just specify the full path and filename of your database as the program to be run. e.g. c:\etc\mydb.mdb
I have a database that runs every day to analyse and print our incoming emails and it works fine.
HTH,
pjm