Sort Week day

  • Thread starter Thread starter Pietro
  • Start date Start date
P

Pietro

Hi,
I have a field "Received" in a query formatted General date,i added
another field to extract the week day using the formula
Day:format([received],"ddd") now i want to sort the field day ascendingly in
a week that starts from Sun,i tried to sort it but actually it's sorted
alphapetically,can aybody help?
 
Use the Weekday() function, which returns the day numbers, as in:

Weekday([Datefield])
 
(...)
I have a field "Received" in a query formatted General date,i added
another field to extract the week day using the formula
Day:format([received],"ddd") now i want to sort the field day ascendingly
in
a week that starts from Sun,i tried to sort it but actually it's sorted
alphapetically,can aybody help?
Click to expand...

Add calculated field
WeekDay([received],1)
and sort by this expression.

K.P. Poland
www.access.vis.pl
 
Back
Top