Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Fiscal Date - Quarterly Report Issue

Status
Not open for further replies.
pbundrant

pbundrant

Technical User
Feb 24, 2002
51
US

Hello all,
I am having a wonderful time trying to find the solution to my problem. I have looked and looked and every solution to fiscal year problems, don't apply to my particular issue.

Please help.

I have created a simple report to show all the work orders completed between certain dates (user entered). It groups by quarters but instead of it displaying "Q1 - 2002" I need it to display "Q3 - 2002". Our fiscal year starts July 1.

Is there a quick fix that can be entered into the same field of the report that displays "QX - 200X"? Just to change what is displayed, like an IF statement that I have seen on this message board, but didn't work in my case.

Oh, and I am VB illiterate. I have tweaked it but never written it myself.

Thanks so much....

PMB s-)
 
Status
Not open for further replies.

Similar threads

JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
497
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Print multiple copies of report data 1
Replies
5
Views
477
dhookom
dhookom
SamuelR
  • Locked
  • Question
Dlookup in a report
Replies
13
Views
564
dhookom
dhookom
monkeysee
  • Locked
  • Question
Muti Page Report 1
Replies
5
Views
469
dhookom
dhookom
BallunarCrew
  • Locked
  • Question
Report Header and Column Formatting Issue 1
Replies
2
Views
628
BallunarCrew
BallunarCrew

Part and Inventory Search

Sponsor

Back
Top