How to report by fiscal qtr's?

J

jim surfer

How to report by fiscal qtr? Can the crosstab function be changed to show Q1
starting in Nov.?
 
J

John Vinson

How to report by fiscal qtr? Can the crosstab function be changed to show Q1
starting in Nov.?
Click to expand...

FiscalQuarter: DatePart("q", DateAdd("m", 2, [datefield]))


John W. Vinson[MVP]
 
J

jim surfer

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.



John Vinson said:
How to report by fiscal qtr? Can the crosstab function be changed to show Q1
starting in Nov.?
Click to expand...

FiscalQuarter: DatePart("q", DateAdd("m", 2, [datefield]))


John W. Vinson[MVP]
Click to expand...
 
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.
Click to expand...

Try FiscalQtr: Format(DateAdd("m", 2, [Table2].[Date]), "\Qqyy"))


John W. Vinson[MVP]
 
J

jim

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.
Click to expand...

Try FiscalQtr: Format(DateAdd("m", 2, [Table2].[Date]), "\Qqyy"))


John W. Vinson[MVP]
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Percent Help 2
reporting date in fiscal qtr's 7
Report Wizard - Group by - Fiscal Year 2
Like to start using Access 1
Queries & Fiscal weeks 7
Add fiscal year to report using crosstab 1
Make table query only runs from design view. 3
URGENT HELP - SUM FORMULA 5

Top