By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,015 Members | 985 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,015 IT Pros & Developers. It's quick & easy.

Sort and list by month

P: n/a
This one is related to my previous question.

My (Access) database contains events. I'd like to
sort and list by month and year, like the example
under here.

Any tips on how to do this would be appreciated.

2005
November
Event
Event
Event

2005
December
Event
Event
Event

2006
January
Event
Event
Event

2006
February
Event
Event
Event
May 10 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Torbjorn ,
if you have a Date field in your d.b. (i.e. EventDate ) you have to
write the next SQL...
SQL = "Select event from TABLE1 group by year(EventDate), month(EventDate)"

Ferg

"Torbjorn Pettersen" <to******@fantafiction.com> escribió en el mensaje
news:12*************@corp.supernews.com...
This one is related to my previous question.

My (Access) database contains events. I'd like to
sort and list by month and year, like the example
under here.

Any tips on how to do this would be appreciated.

2005
November
Event
Event
Event

2005
December
Event
Event
Event

2006
January
Event
Event
Event

2006
February
Event
Event
Event


May 10 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.