Mombu the Programming Forum sponsored links

Go Back   Mombu the Programming Forum > Programming > I'm rusty on my Access knowledge....can anyone help me with this Query question?
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 30th April 08:32
caspers friend
External User
 
Posts: 1
Default I'm rusty on my Access knowledge....can anyone help me with this Query question?


It's been a while since I've had to build anything in Access, so f****ve 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
  Reply With Quote


  sponsored links


2 30th April 08:32
scott mcdaniel
External User
 
Posts: 1
Default I'm rusty on my Access knowledge....can anyone help me with this Query question?


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
http://www.thedatabaseplace.net
  Reply With Quote
Reply


Thread Tools
Display Modes




Copyright 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666