Hi all,
I created a Query in Access that is picking up data from only one table. The intention is to create new fields in the query using IF statements like COMQ2: IIf([Resolution] Like "*COMQ2*","COMQ2").
I use this query in a PivotTable Object where the field COMQ2 is available. The problem is that this field seems to contain no data. I drag the field into the pivot table and it only shows "blank" and no "COMQ2". I checked in the query and the is data there as "COMQ2" but it doesn't show in the PivotTable.
Am I missing something here? Do I need to define the data as String somewhere
I need to mention that the Access PivotTable does seem to work ok as a Form in Access, but I am using a PivotTable object in a Data Access Page, there it does not work.
Thanks a lot for the help!
Best regards
Marcel
I created a Query in Access that is picking up data from only one table. The intention is to create new fields in the query using IF statements like COMQ2: IIf([Resolution] Like "*COMQ2*","COMQ2").
I use this query in a PivotTable Object where the field COMQ2 is available. The problem is that this field seems to contain no data. I drag the field into the pivot table and it only shows "blank" and no "COMQ2". I checked in the query and the is data there as "COMQ2" but it doesn't show in the PivotTable.
Am I missing something here? Do I need to define the data as String somewhere
I need to mention that the Access PivotTable does seem to work ok as a Form in Access, but I am using a PivotTable object in a Data Access Page, there it does not work.
Thanks a lot for the help!
Best regards
Marcel
Last edited:
