Don't know if this is the correct forum for this question. Hope it is.


Created a pivot table and record source is from a crosstab query. Works perfectly.

Created another pivot table from similar crosstab query. Only difference is that one field is false instead of true. The data produced in the Pivot Table is the same from the first query even when I refresh data. (In other words the Pivot table is not taking the data from the record source.)

Any assistance is appreciated.

Lar