Log in

No account? Create an account
10 March 2004 @ 02:43 pm
Access Question  
How do I delimiting the fiscal months and quarters somehow so that when entries are made for a certain date they are categorized in the appropriate fiscal period for later calculations (I hope that makes sense)?

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?

-the redhead-

ya larn summin' new ever' day...
Christopher Scottkorwyn on March 12th, 2004 09:37 am (UTC)
Add a calculated field behind your entry template to calculate the FY quarter.
-the redhead-theredhead on March 12th, 2004 09:53 am (UTC)
Re: Access
Yes, I know that part and I already have placeholders there. What I'm looking for is the logic statement used to calculate the month and quarter.

-the redhead-