M
Megan
Can you put queries in your report?
For example,
can I display
I want to list prices for tables of different sizes -
so can I have a criteria on the value in the size field and list it in columns.
Category
Product Size Size Size
---------------------------------------------------
table $5.00 $10.00 $15.00
I would be saying - somewhere - the first size=2ft, display all of those , the second size=3 ft, display all of those.
They are all actually in the "size" field.
This probably isn't clear. I've been getting myself all mixed up.
I tried the crosstab with first but then I can only get one value.
Thanks.
For example,
can I display
I want to list prices for tables of different sizes -
so can I have a criteria on the value in the size field and list it in columns.
Category
Product Size Size Size
---------------------------------------------------
table $5.00 $10.00 $15.00
I would be saying - somewhere - the first size=2ft, display all of those , the second size=3 ft, display all of those.
They are all actually in the "size" field.
This probably isn't clear. I've been getting myself all mixed up.
I tried the crosstab with first but then I can only get one value.
Thanks.