M
mike
Hi there. I have a table that lists all types of orders of
products that are shipped out. The query is qryShipped and
the important fields are InvoiceDate and DollarsShipped.
I'm trying to group all the shipments by date and sum the
dollars shipped on each date. The tricky part is that all
shipments for Friday-Sunday are considered as one day. So,
I would have Mon, Tues, Wed, Thurs, Fri-Sun. I can't seem
to figure out how to make an exception that groups Fri-
Sun. Any suggestions would be great. Thanks!
products that are shipped out. The query is qryShipped and
the important fields are InvoiceDate and DollarsShipped.
I'm trying to group all the shipments by date and sum the
dollars shipped on each date. The tricky part is that all
shipments for Friday-Sunday are considered as one day. So,
I would have Mon, Tues, Wed, Thurs, Fri-Sun. I can't seem
to figure out how to make an exception that groups Fri-
Sun. Any suggestions would be great. Thanks!