qDOM = Calendar day of month 1-31
qMonth = The month
qDOW = Alpha day of week (Sun ... Sat)
qJDate = Julian day
qAP = Day of the accounting period, based on a 28 day month. No correlation to actual calendar date.
Yes, I can generate the first three variable from a single date, and maybe the julian date, but I still need to pass to the query.
Other information that will be provided in number of days to run. That means that the query would be run x times to produce x schedules.
I've been doing it manually, but my co-workers are tech writers and I don't want to risk them missing a variable and not getting the schedules correct.
All for Disaster Recovery.
FWIW, I'm learning Access on the fly. All pointer are appreciated.
I'm trying Jay's VB suggestions and getting an error "Object Required" on the Set Query1 = line