Hi all
I am working on some management accounts but the end user has poor
excel/access skills so I need to automate everything.
The current set up is a query in access that is ex****ted manually to excel
and then used to create a pivot table.
Every month the data is ex****ted again and the pivot table range is
updated
to take into account the new rows.
I would like to be able - from excel - to just refresh the data through a
button led macro or autorefresh by having a direct link between excel and
access.
------
The obvious choice was to use the im****t external data function in excel
and
"rewrite" my query in "Microsoft query", but I can't get MS query to run
an
IF function.
My IF function in Access is the following:
Amounts: IIf([Analysis]="A - Overheads",-[Amount]*[Allocation
rate],-[Amount])
In advance, Thank you
