G
Guest
How to report by fiscal qtr? Can the crosstab function be changed to show Q1
starting in Nov.?
starting in Nov.?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John Vinson
How to report by fiscal qtr? Can the crosstab function be changed to show Q1
starting in Nov.?
FiscalQuarter: DatePart("q", DateAdd("m", 2, [datefield]))
John W. Vinson[MVP]
G
Guest
Is this correct syntax?
Fiscal Qtr: DatePart("q",DateAdd("m",2,[Table2]![Date]))
I get an error message when trying to run this crosstab query. (data type
mismatch in criteria expression).
Also, reporting by fiscal qtr and year would be great. i.e., Q404, Q105,
Q205 etc.
Fiscal Qtr: DatePart("q",DateAdd("m",2,[Table2]![Date]))
I get an error message when trying to run this crosstab query. (data type
mismatch in criteria expression).
Also, reporting by fiscal qtr and year would be great. i.e., Q404, Q105,
Q205 etc.
John Vinson said:How to report by fiscal qtr? Can the crosstab function be changed to show Q1
starting in Nov.?
FiscalQuarter: DatePart("q", DateAdd("m", 2, [datefield]))
John W. Vinson[MVP]
J
John Vinson
Is this correct syntax?
Fiscal Qtr: DatePart("q",DateAdd("m",2,[Table2]![Date]))
I get an error message when trying to run this crosstab query. (data type
mismatch in criteria expression).
Also, reporting by fiscal qtr and year would be great. i.e., Q404, Q105,
Q205 etc.
Try FiscalQtr: Format(DateAdd("m", 2, [Table2].[Date]), "\Qqyy"))
John W. Vinson[MVP]
G
Guest
works great, thanks!!
John Vinson said:Is this correct syntax?
Fiscal Qtr: DatePart("q",DateAdd("m",2,[Table2]![Date]))
I get an error message when trying to run this crosstab query. (data type
mismatch in criteria expression).
Also, reporting by fiscal qtr and year would be great. i.e., Q404, Q105,
Q205 etc.
Try FiscalQtr: Format(DateAdd("m", 2, [Table2].[Date]), "\Qqyy"))
John W. Vinson[MVP]