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

Sort by month

Status
Not open for further replies.
JCAA

JCAA

MIS
Jun 22, 2003
65
US
I am not sure how I can do this. I have a table and I need to sort out certain part numbers and sort them by month. How will I do that when I have date in there. I need the whole month sale together and not by each date? Can I group it by whole month somehow?

Thanks!
 
Sort by date Sort by votes
It isn't clear at all what you want. Are you only summarizing by month or do you also need details? Is this to be grouped in a report or just a query?
You can group by Format([DateInThere],"yyyymm")


Duane
MS Access MVP
Find out how to get great answers faq219-2884.
 
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
JayRo71
  • Locked
  • Question
Unable to sort date field
Replies
4
Views
474
JayRo71
JayRo71
TrekBiker
  • Locked
  • Question
Use two sorts in query 1
Replies
7
Views
509
TrekBiker
TrekBiker
WimDC
  • Locked
  • Question
Help on grouping by TIME Range
Replies
1
Views
365
dhookom
dhookom
MattGreer
  • Locked
  • Question
Can't update a field from a query result due to 'Group By'
Replies
2
Views
255
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top