Report layout

[ema]

I want to change the layout of my report - I have about 5 fields to put in
it. I want it in a columnar design for 4 of the 5 fields (date, line,
product, total hours) - and the last field (color)I want it to be towards the
right and each item in the field (blue, red, yellow, orange, green) to be a
column with the quantity under it, so it would look like this:

Date Line Product Total Hours blue red yellow
orange green

1/1/07 2 X164 9.5 1 3
2 4


My form has them entering date, line, product, total hours, and then in the
subform - they choose one color from the list and enter the quantity, and
then choose another color if necessary and enter the quantity.

How do I set the report up to give me this result?

 

[KARL DEWEY]

Try this substituting your table and field names in the SQL ---
TRANSFORM Count(Ema.Color) AS CountOfColor
SELECT Ema.ActionDate, Ema.Line, Ema.Product, Sum(Ema.Prod_Hours) AS [Total
Hours]
FROM Ema
GROUP BY Ema.ActionDate, Ema.Line, Ema.Product
PIVOT Ema.Color;