SELECT DatePart("ww",ShipDate) as TheWeek,
FROM ALL_SOP_ORDERS INNER JOIN ALL_SOP_ORDERS_DTL
ON ALL_SOP_ORDERS.SOPNUMBE =
WHERE ALL_SOP_ORDERS.ShipDate >= '1/5/2003'
GROUP BY TheWeek,LOCNCODE,ITEMNMBR
I'd like to add an additional field which would display that Sundays
date for TheWeek.
For instance, if Shipdate was 1/7/2003 and TheWeek is 2 then I'd like to display that Sunday, 1/5/2003.