I am having major problems trying to sort my report by days of the week. I have converted the date into weekdays but it still trys to sort it by the date (numerically). is this poss. and if so what do I do?
The method I have used to add the day of the week is to add another text box and enter =[date] and then go into properties/format and entered "ddd".
Mon, Tue etc. shows up on the report but when I try to sort by that box it still insists on sorting by the numerical date.
I've also put a line in the query in a similar manor but it won't even sort correctly using that method.
Before I get bald trying, could anyone come to my rescue.
The method I have used to add the day of the week is to add another text box and enter =[date] and then go into properties/format and entered "ddd".
Mon, Tue etc. shows up on the report but when I try to sort by that box it still insists on sorting by the numerical date.
I've also put a line in the query in a similar manor but it won't even sort correctly using that method.
Before I get bald trying, could anyone come to my rescue.
