日历年与财政年度 [英] Calendar year versus Fiscal year

问题描述

我有一个查询，将日期分为几个季度。问题在于它将它作为第一季度放入jan-mar。我需要2008年的jul-sep为2009年第1季度和jan-mar为2009年第3季度。任何想法？

I have a query that puts dates into quarters ofr me. The problem is that it puts it into jan-mar as quarter one. I need jul-sep of 2008 to be q1 2009 and jan-mar to be q3 2009. Any ideas?

推荐答案

@rcollins

您可以使用Query与计算字段的组合，通过公共函数返回正确的Quarter。我使用Northwind数据库的Orders表进行此演示：

• 使用计算字段查询：
  

@rcollins
You can use the combination of a Query with a Calculated Field, that returns the proper Quarter via a Public Function. I used the Orders Table of the Northwind Database for this demo:

• Query with Calculated Field:
  

< span class =codeLinkonclick =Blur（this，this.parentNode.parentNode，getChildren（this），true）;>展开 | 选择 | Wrap | 行号

所以，我认为我在很大程度上理解这一点，但我看到一两个问题。首先，我在哪里保留这个功能？我在模块中这样做吗？此外，这似乎是特定年份。我希望能够使用报告的标准表格，我是否必须不断更改日期，或者有没有办法在任何一年做到这一点？那么7月到2008年12月实际上是2009财年的一部分呢？似乎这个查询仍会在错误的一年中列出这几个月。

感谢您的帮助，您非常感兴趣

So, I think I understand this to the most part, but I see an issue or two. First, Where to I keep the function? do I do this in a module? Also, This seems to be year specific. I would like to be able to use a criteria form for the report, will I have to keep changing dates or is there a way to do this for any year? What about the fact that july through dec 2008 are actually part of fiscal year 2009? it seems that this query would still list these months in the wrong year.
Thanks for all your help, you are very appriciated

@rcollins

@rcollins

我在哪里保留这个功能？

Where to I keep the function?

在标准代码模块中

In a Standard Code Module

我是否在模块中执行此操作？

Do I do this in a module?

之前的回答

Previously answered

我希望能够使用报告的标准表格，我必须不断更改日期，或者有没有办法在任何一年这样做？

I would like to be able to use a criteria form for the report, will I have to keep changing dates or is there a way to do this for any year?

它可能会被转换为接受任何年份

It can probably be converted to accept any Year

7月到2008年12月这个事实怎么样？实际上是2009财年的一部分？似乎这个查询仍会在错误的一年列出这些月份。

What about the fact that july through dec 2008 are actually part of fiscal year 2009? it seems that this query would still list these months in the wrong year.

也许我很困惑，（财政上非法），但2008年7月被认为是2009财年的第1季，并且不是2008年12月被认为是2009财年第3季度？

PS - 请回复具体细节。

Maybe I''m confused, (fiscally illerate), but isn''t July 2008 considered to be Quarter 1 of Fiscal Year 2009, and isn''t December 2008 considered to be Quarter 3 of Fiscal Year 2009?

P.S. - Kindly Reply with specifics.

这篇关于日历年与财政年度的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！