It's been a while since I've had to build anything in Access, so forgive me
if this is simple...I'm probably just having quite the mental block here.

I have a fairly simply query...3 fields which are just grouping and
counting....my fields are:
Day / #of Files / # of Days(this month) - which I would like to read like :
MON / 64 / 3
TUE / 64 / 2
WED / 38 / 2
THU / 49 / 2
FRI / 50 / 2
SAT / 25 / 2
SUN / 25 / 2

I would simply like to sort by the day of the week - Monday thru
Sunday....however my query is wanting to alphabetize the MON thru SUN
instead of putting it in daily order. Is there anyway to override this and
tell it that I want it to go MON, TUE,...etc? I also thought that I could
put another field on the query that would read the data (DAY) and covert it
into a value that I could sort by....ie... If DAY="MON" then 1, If DAY =
"TUE" then 2, etc... is this possible?

Sincerely,

A frustrated Casper's Friend :-P

Please don't crosspost. This question was answered in another newsgroup,
however people reading this don't know that.

If you feel that you must post to more than one group (and this is rarely
necessary) then multipost - include all the groups in the Newsgroups header
line. That way, answers in other groups will show up in this group as well.

--
Scott McDaniel
CS Computer Software
www.thedatabaseplace.net

"Casper's Friend" <mycaspermail (AT) yahoo (DOT) com> wrote