pivot query as recordsource

  • Thread starter Thread starter alex
  • Start date Start date
A

alex

I use a pivot query as recordsource of a continuous
form. Row items are time periods, Column items are
product categories. Values are selling incomes.
In the form I have a field for every different category
(fieldname=categoryname).
I can select different periods but if for a certain
period there are no products of a certain category then
the corresponding field value is set to #value?

Is there a way to avoid this?

Thank you
Alex
 
You must hard-code your category names into the column headings property to
the crosstab.
 
Back
Top