Sort Week day

[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?

 

[Arvin Meyer [MVP]]

Use the Weekday() function, which returns the day numbers, as in:

Weekday([Datefield])

 

[Krzysztof Pozorek [MVP]]

(...)

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?

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

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