UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Ms Access Query To Order By Month Names, Access 2010    
 
   
rizmin
post Sep 14 2017, 12:09 AM
Post#1



Posts: 96
Joined: 10-August 17



Hi All!

I want to short the month name as chronological order not alphabet order, I have Date entry field but its multiple data for each month so i can't use group by in Query design, hope there is a way to solve this issue. Thank you all

Go to the top of the page
 
Kamulegeya
post Sep 14 2017, 12:29 AM
Post#2



Posts: 1,765
Joined: 5-September 10
From: Kampala,Uganda The Pearl of Africa


Hi,

Add
CODE
order by Month(YourDateFieldHere)


Ronald
Go to the top of the page
 
rizmin
post Sep 14 2017, 12:43 AM
Post#3



Posts: 96
Joined: 10-August 17



Hi Kamulegeya

I have convert the month by using following expression:

CODE
Month: Format([DateEntry],"mmm")


So How I can apply your code here?
Go to the top of the page
 
Kamulegeya
post Sep 14 2017, 02:53 AM
Post#4



Posts: 1,765
Joined: 5-September 10
From: Kampala,Uganda The Pearl of Africa


Hello,

You want data sorted like 1,2,3,4--12?

So you add order by clause ...can you show your query SQL here?
Go to the top of the page
 
rizmin
post Sep 14 2017, 04:10 AM
Post#5



Posts: 96
Joined: 10-August 17



I have shorted out by resigning my query, Now its is working well. Thank you
Kamulegeya thumbup.gif
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    18th November 2017 - 08:30 PM