A Alibaba New member Local time Yesterday, 19:04 Joined May 29, 2008 Messages 13 Dec 17, 2018 #1 Hi This is Access 2010 and I would like to turn off the underline additional fields added by the pivot form FOR fields of DATE data type Attachments PivotFields.png 8.3 KB · Views: 103
Hi This is Access 2010 and I would like to turn off the underline additional fields added by the pivot form FOR fields of DATE data type
Ranman256 Well-known member Local time Yesterday, 19:04 Joined Apr 9, 2015 Messages 4,354 Dec 18, 2018 #2 cant you make a query and pull only the 3 fields you want, and pivot that?
A Alibaba New member Local time Yesterday, 19:04 Joined May 29, 2008 Messages 13 Dec 18, 2018 #3 those columns are added by the pivot table as an additional grouping for all date fields. they are not part of the underlying query or table. I need to a method or an an option to turn them off.
those columns are added by the pivot table as an additional grouping for all date fields. they are not part of the underlying query or table. I need to a method or an an option to turn them off.
