Soldato
So I'm a complete and utter novice when it comes to Access, and I'm having trouble trying to setup a crude table correctly in order to get the fields in a PivotTable friendly layout.
I need the layout as I'm going to drive a PivotTable from the access database and currently, each fact is a separate field which means I can't utilize a slicer to switch between viewing different facts.
What I want to try and do is change the layout from how it is in the top, to how is should look at the bottom:
upload images
Any ideas? There's some SQL using Union All that I've Googled but it just errors out on me.
I need the layout as I'm going to drive a PivotTable from the access database and currently, each fact is a separate field which means I can't utilize a slicer to switch between viewing different facts.
What I want to try and do is change the layout from how it is in the top, to how is should look at the bottom:
upload images
Any ideas? There's some SQL using Union All that I've Googled but it just errors out on me.