Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    In clause in Pivot query (2003 SP2)

    Can anyone advise me why adding an In clause won
    Regards,
    Peter

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: In clause in Pivot query (2003 SP2)

    The In clause cannot be an SQL statement. It must be a comma-separated list of values.
    If you create the SQL statement in VBA, you can loop through the records of qryBKzTasksForPlanning to assemble the In clause, but if you design the query interactively, you can only type in the list of values.

  3. #3
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: In clause in Pivot query (2003 SP2)

    I was led astray by the Help files that show In clauses using SQL satements. But on closer inspection, yep, you're right (again), only value lists in Transform statement's In clauses.
    Thanks again Hans.
    Regards,
    Peter

Posting Permissions

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