Sort Week day

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pietro - 12 Jan 2008 15:48 GMT

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?

Reply to this Message

Arvin Meyer [MVP] - 12 Jan 2008 15:59 GMT

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

Weekday([Datefield])

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

> Hi,
> I have a field "Received" in a query formatted General date,i added
[quoted text clipped - 3 lines]
> a week that starts from Sun,i tried to sort it but actually it's sorted
> alphapetically,can aybody help?

Reply to this Message

Krzysztof Pozorek [MVP] - 12 Jan 2008 16:04 GMT

(...)

> 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

Reply to this Message