group by day

[shutzy]

i want to create a report between dates but group the results by day. ie. monday tuesday wednesday etc.

i can group by date but not sure of how to do this one.

i thought that i would have to use format in the date column of the query and then select group.

is this the best way or is there a better way.

thanks

 

[plog]

You would do this using the Weekday (http://www.techonthenet.com/access/functions/date/weekday.php) and WeekdayName (http://www.techonthenet.com/access/functions/date/weekdayname.php) functions.

ReportDay: WeekdayName(Weekday([YourDateFieldHere]))

 

[pr2-eugin]

Hello shutzy, You can use the Weekday function to get the right Weekday then use Group By on that field..

SELECT Weekday(theDateField, vbMonday) AS randomName 
FROM theTableName
GROUP BY Weekday(theDateField, vbMonday)

 

[Brianwarnock]

My query would have fields for weekday and weekdayname.
The report would group on both in that order, but I would remove the group header for dayno and make the field invisible, thereby ending up with a report in day order but showing daynames

Brian