Appreciate your help, though I disagree that its entirely a different question.
Whenever I create a query from a table, the query will not allow me to amend the field properties, nor does it bring in the format from the table I am querying on. All I can see is the blacked out version I posted before.
In past reports, I have been able to wrap the field queries in a format( , "Currency") type formula for currency and percentage points and this has resolved it. When I Copy and Paste (not export) the report maintains all the formatting in Excel that has been added by the formula.
This particular report, I am backwards engineering a set of reports someone else has created, manually, in EXCEL, which is why I need to convert the full date eg. 20/12/2019 into DEC 20. I have done a formatting query for from the field next to it (now improved, thanks to a suggestion earlier in the thread), but after running, copying and pasting into EXCEL, the pre-set pivots are showing all the MMM YY columns out of order. The data copied from ACCESS has the format in EXCEL as 'General', which leads me to believe that the query has created the detail as Short Text, but I cant check or amend that as the options are blanked out.
Without being able to change the properties, because the properties table is blanked out, I am unable , without formatting that column in EXCEL for 9 reports every month, to have the pivots order themselves properly.
This is an issue I have had to find workarounds for for about 2 years and cant find any other reference apart from this thread, but the solution doesn't seem to be working.
I am running ACCESS through Office 365 on a work account.