Get & Transform with a parameter from Access query

udigold1

New Member
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

This Week's Hot Topics

Top