C
Capt James Cook
Please help. I have an Orders table with Ord#, ReceivedDt, ShipDt and I need
a query that will summarize activity by date.
Sample data:
Ord# Recv Ship
0001 10/10/07 10/13/07
0002 10/12/07 10/12/07
0003 10/12/07 10/13/07
Output summary needs to count activity by date as follows
Date Received Shipped
10/10 1 0
10/12 2 1
10/13 0 2
Your assistance will be greatly appreciated.
a query that will summarize activity by date.
Sample data:
Ord# Recv Ship
0001 10/10/07 10/13/07
0002 10/12/07 10/12/07
0003 10/12/07 10/13/07
Output summary needs to count activity by date as follows
Date Received Shipped
10/10 1 0
10/12 2 1
10/13 0 2
Your assistance will be greatly appreciated.