[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 320
  • Last Modified:

Pivot Refresh - Access Link

Hi,

I have a pivot table linked to an Access Table.

I have attached what thye table looks like.

If i refresh today, the date 16/08/2012 will fall to the right of the table, i.e. it will replace 09/08/2012. I need it to be at the very left hand side of the pivot (where 15/08/2012 is) and everytrhing else move one to the right

How can i make the pivot do this?

Thanks
Seamus
test.xlsx
0
Seamus2626
Asked:
Seamus2626
1 Solution
 
Elton PascuaCommented:
Right-click on any date field > Sort > More Sort Options. Choose Descending then choose the Date Field on the drop down. Click OK. That should sort your columns with the most recent date on the left.
0
 
Seamus2626Author Commented:
Excellent, thank you techfanatic
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now