Table Development question
Posted on 2014-09-03
Experts, I am developing a table but need a little help.
I have :
I have many reporting requirements and they are either Quarterly, Semiannually, Annually and within a certain number of days past those points. For example, an annual report would be within 120 days after years end and a quarterly is within 60 days past the quarter.
My question is, do I hard code [withindays] (ie 120, 60) as a field in a table? Or is it better some other way (maybe within a query)