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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date field to sum as Month example Mar 08

Status
Not open for further replies.
dwight1

dwight1

IS-IT--Management
Aug 22, 2005
176
US
Can some body please help me format my date field to look lik Mar 08.

I am using cross tab and i want the date field to be months so that i can use it as columns headings.

The report should look like this:
Sep 08 Oct 08 Nov 08
XXX
YYY
ZZZ
XXX

Any help is appreciated.

Thanks
 
Sort by date Sort by votes
Please ignore..found the answer in group options of cross tab.

Thanks
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

B
  • Question
Difference of a field between 2 variable dates
Replies
1
Views
153
hilfy
hilfy
T
  • Locked
  • Question
Date comparison Formula
Replies
2
Views
353
TPG_IT
T
D
  • Locked
  • Question
Comparing two Date Ranges
Replies
0
Views
222
doodledump
D
socalvelo
  • Locked
  • Question
Extract Phone Numbers from Text Field
Replies
0
Views
206
socalvelo
socalvelo
Cpreston
  • Locked
  • Question
Select Top 2 rows where field = 2,3,4 and 5
Replies
1
Views
216
Cpreston
Cpreston

Part and Inventory Search

Sponsor

Back
Top