Results 1 to 3 of 3
  1. #1
    Join Date
    May 2014

    Unanswered: Need help for Fiscal Month Query

    CAn you please help me return monthly data on a fiscal month:

    my monthly cut-off is every 6th of the month. Therefore I need data returned from every 6th day of the month to 5th day of the following month. That is on a monthly basis.

    Thnak you

  2. #2
    Join Date
    Apr 2014
    Provided Answers: 34
    Click image for larger version. 

Name:	rpt date.png 
Views:	1 
Size:	9.3 KB 
ID:	15485

    I have the users pick their time range for the report. (see pic)
    YOUR version will set the StartDate and EndDate to the fiscal year settings.

    The query will use the text boxes on the form in the criteria:

    ...where [RunDate] between forms!frmRpts!txtStartDate
    and forms!frmRpts!txtEndDate.

  3. #3
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    Different accounting systems handle non-standard fiscal months in different ways. Most of the answers to this kind of question are easy to implement, and about 91% correct. A monthly total that is 91% correct isn't going to make your auditors happy!

    Which accounting system (and if applicable which calendar system) are you using for this system?

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts