Results 1 to 2 of 2

Thread: Get & Transform with a parameter from Access query
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Dec 2008
    Posts
    42
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Get & Transform with a parameter from Access query

    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,

  2. #2
    Board Regular
    Join Date
    Jan 2012
    Posts
    844
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Get & Transform with a parameter from Access query

    Pull back all of the data from Balances and then use Power Query to filter to your required CorpId.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •