Get & Transform with a parameter from Access query

udigold1

New Member
Joined
Dec 15, 2008
Messages
44
Hi there,
I was wondering how can I use a parameter in a query using the "Get & Transform" .
For simplification purposes, I have a saved query called 'dbQuery':
Code:
select * from Balances where Balances.CoprID=[Idpara]
IdPara is the parameter.

"Get & transform" doesn't recognize this query because it has a parameter and I know I have to drop the parameter so that "Get & transform" will recognize it.
But how do I use it to get the same result as if I were using the parameter?
Thanks,
 

theBardd

Rules violation
Joined
Jan 21, 2012
Messages
912
Pull back all of the data from Balances and then use Power Query to filter to your required CorpId.
 

Forum statistics

Threads
1,085,210
Messages
5,382,369
Members
401,784
Latest member
Jonnyboisme

Some videos you may like

This Week's Hot Topics

Top