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,
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,096,192
Messages
5,448,885
Members
405,537
Latest member
muh6323

This Week's Hot Topics

Top