-
I'm not sure if that's the right way to go about this, so let me explain my problem:
I have a set of queries (8) that use the same report but take different cuts of the data based on certain parameters, normally date ranges.
Normally I would build a function or two to calculate the proper ranges, but these queries follow some odd business rules that force you to think about the right dates, and it's easier to set them up on a monthly basis manually.
Well, being a lazy, lazy man, I want to write up a procedure that prompts (via msg box) for the new date ranges, and then saves them.
Am I on the right track in editing the module, and if so, what would be the best way to do so?
I think we're talking about 8 dates, some of which can be shared between queries.
-
Is that 8 dates or 8 pairs? I'd give some thought to creating a table with 3 fields (index, startdate, enddate) then join this table in your queries. Then you could write a simple program (or update the data in Access) to update the dates prior to running the 8 reports
