For example Q1 FY05 is split into:
May FY05 5/1/04 - 5/28/04
June FY05 5/29/04 - 7/2/04
July FY05 7/3/04 - 7/30/04
I want to calculate month & quarter data by capturing entries by the received date and have it assign it to the correct fiscal period(s)
How do I tell Access this?
ya larn summin' new ever' day...