Not a typical 'Weekend' query question

[elsenorjose]

I am using the following query to give me order counts for weekend days:

SELECT Table.Date,
Sum(Table.[OrdCt]) AS [SumOfOrdCt]
FROM Table
WHERE (((Table.StoreID) In ('1', '2', '3', etc...))
AND ((Weekday(

.[Date])) In (1,7)))
GROUP BY Table.Date;

This gives me a sum of orders for Saturdays and Sundays. I need to modify this to return Fridays as well. A weekend for a store is Friday through Sunday so this query shorts me by a day. Not sure how to do it if it's even possible.

Using MS Access 2003 with Office SP2 on Windows XP with SP2.

Thanks in advance.

 

[PHV]

AND ((Weekday(

.[Date])) In (1,6,7)))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[elsenorjose]

Yeah, I figured it was something simple like that. It's all little things ain't it?

Thanks.