which is better?

[Eric Nelson]

I'd like to restrict a set of reports to a certain time
period -- this or that month, quarter, year, etc. Which is
better, to parameterize the report (launching it from a
form), parameterize the query underlying the form, or to
join the table with a table of the pertinent time periods?

Thanks for insight...

Eric

 

[Jeff Boyce]

Eric

Creating a table for each time period will give you more headaches,
downstream, that you can possibly know -- don't do it! That approach is
necessary if your tool is Excel, but you lose the relational database
capabilities of Access if you try to use it as a spreadsheet.

You didn't mention what your data structure or data elements were -- it
might make a difference on how folks advise you...

More info, please...

Jeff Boyce
<Access MVP>