Access Pivot Additional Columns (1 Viewer)

A

Alibaba

New member

Local time

Today, 16:32

Joined

May 29, 2008

Messages

8

• 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: 50

Ranman256

Well-known member

Local time

Today, 16:32

Joined

Apr 9, 2015

Messages

4,339

• 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

Today, 16:32

Joined

May 29, 2008

Messages

8

• 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.