Hello all
I'm trying to create a pivot chart based on a query with an ID + 6 entries for data to be displayed. I have created the form for the Pivot chart/table to created from.
Now, the form displays the ID and the respective 6 reporting aspects from the original query without a problem, however when I opt for the Pivot table to be created, I only receive the ID and 3 of the respective reporting aspects within the field list option. I have no idea why the other 3 fields that can be seen within the query/form are missing from the field list within the Pivot chart/table.
May I please request some advice and what further information would you require (if you would like to help) to solve this.
many thanks in advance
Phil
I'm trying to create a pivot chart based on a query with an ID + 6 entries for data to be displayed. I have created the form for the Pivot chart/table to created from.
Now, the form displays the ID and the respective 6 reporting aspects from the original query without a problem, however when I opt for the Pivot table to be created, I only receive the ID and 3 of the respective reporting aspects within the field list option. I have no idea why the other 3 fields that can be seen within the query/form are missing from the field list within the Pivot chart/table.
May I please request some advice and what further information would you require (if you would like to help) to solve this.
many thanks in advance
Phil
