By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,871 Members | 2,444 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,871 IT Pros & Developers. It's quick & easy.

Fiscal Calendar

P: n/a
I do fair amount of data analysis using access pivot tables and charts. Can
any body suggest a method to run the queries based on accounting month and
Accounting year.As an example: I want to analyze sales order per month and
per Quarter. Our fiscal First quarter starts at 1st April with start date as
April 1st and End date as 29 April ( Each month ends at Last Sunday of that
month)

I appreciate any comments.
Thanks in advance

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200703/1

Mar 9 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Think there may be a problem. A FYquarter that begins on 1 April would
logically terminate on 30 June, not 29 April. How's a thing like this work?

Bob

Sund wrote:
>I do fair amount of data analysis using access pivot tables and charts. Can
any body suggest a method to run the queries based on accounting month and
Accounting year.As an example: I want to analyze sales order per month and
per Quarter. Our fiscal First quarter starts at 1st April with start date as
April 1st and End date as 29 April ( Each month ends at Last Sunday of that
month)

I appreciate any comments.
Thanks in advance
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200703/1

Mar 9 '07 #2

P: n/a
raskew wrote:
>Think there may be a problem. A FYquarter that begins on 1 April would
logically terminate on 30 June, not 29 April. How's a thing like this work?

Bob
>>I do fair amount of data analysis using access pivot tables and charts. Can
any body suggest a method to run the queries based on accounting month and
[quoted text clipped - 5 lines]
>>I appreciate any comments.
Thanks in advance
Sorry for the confusion.
First Quarter : From 1 April to June 30: Second Quarter: From 1 July to 30
Sept; Third Quarter: From 1 Oct to 31 Dec; Fourth Quarter: From 1 Jan to 31
March..

Months - April : 4/1 to 3/29; May: 4/30 to 5/27; June: 5/28 to 6/30 and so
on

Hope this clarfies the confusion

Sund

--
Message posted via http://www.accessmonster.com

Mar 9 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.