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

Display Month

Status
Not open for further replies.
shart00

shart00

Technical User
Jun 16, 2003
63
US
There is a field [Edate] that currently has an exact date. In the query, I need it to display as the Month. I.E. 4/25/04 to display as April

any suggestions on how to do this in the query?
 
Sort by date Sort by votes
In the query grid:
[Month]: Format({Edate], 'mmmm')

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question
12 Month Rolling Average 2
Replies
15
Views
1K
Swi
Swi
spartansFC
  • Locked
  • Question
Display Year between 2 dates 1
Replies
1
Views
735
dhookom
dhookom
supportsvc
  • Locked
  • Question
Query to Display $0 if no record in Quarter with YTD total
Replies
14
Views
851
supportsvc
supportsvc
supportsvc
  • Locked
  • Question
Distinct Count for Unique Number of Employees in Each Month
Replies
0
Views
230
supportsvc
supportsvc
0sprey
  • Locked
  • Question
Query by Month-Year and with a Record Count Field
Replies
1
Views
288
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top