-the redhead- (theredhead) wrote,
-the redhead-

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...
  • Post a new comment


    default userpic

    Your IP address will be recorded 

    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.