Spreading data to date columns

[John2110]

My orders table has the following fields: OrderNum, Cust, Part, Qty, ShipDate.

I need to print one order per line but move the qty under a column with the
ship date.

Ord# Cust Part PastDue 2/13 2/14 2/15 2/16
123 ABC 6543 50
124 ABC 6548 75
127 RST 7125 50
129 RST 8567 50

 

[Duane Hookom]

You can use a crosstab query. Are the dates all consecutive as you posted?
There is a sample monthly crosstab report that could be modified to report by
day rather than month.
http://www.tek-tips.com/faqs.cfm?fid=5466