Subreport layout

[Jeff F]

My database has a main report that contains several subreports. I've created
a form so i can enter a date range to be used for all subreports. On one sub
report, I want the layout to be:
Day Small Medium Large (Header)
Monday 5 7 10 (example data, numbers
are quantities)

My query I pull the data from has 3 fields:
Day, Size, qty. where there will be 3 entries for each day(sm, med, lrg).
My problem is the query has the field "size" but i need text boxes to
display for "small, medium, & large". I don't know if i need to manipulate
the criteria in the query or what. I can get it to return one size but when i
try for a second, the subreport returns zero data.
This seems very simple but i don't have a clue.

 

[Duane Hookom]

You should be able to create a crosstab query where the day is the row
heading, Size is the column heading, and Sum of Qty as the value.

Set the column headings property to the possible values of Size.

 

[Jeff F]

I think that will work! Thanks Duane.

You should be able to create a crosstab query where the day is the row
heading, Size is the column heading, and Sum of Qty as the value.

Set the column headings property to the possible values of Size.