Table list in CrossTab Pivot statement

Discussion in 'Microsoft Access Queries' started by Guest, Feb 8, 2007.

  1. Guest

    Guest Guest

    There might be an eaiser way to do this, but I am in a hurry and have
    existing queries I need to fix.

    I have a crosstab query where the column headings are derived from a table.
    I would rather not have to type in all the values of that table into the IN
    clause(although there are only 10 or so), since those values might change.
    Is it possible to use that as a source for the IN statement of the PIVOT
    clause of my crosstab?

    Thanks
    --
    Fictionally Yours, Biggles
     
    Guest, Feb 8, 2007
    #1
    1. Advertisements

  2. Guest

    Guest Guest

    "Is it possible to use that" what do you mean by "that"? You can't use a
    table or select statement in the IN () clause of a crosstab query. You can
    use DAO code to dynamically build your SQL statement and apply it to the
    saved crosstab QueryDef.
    --
    Duane Hookom
    Microsoft Access MVP


    "Biggles" wrote:

    > There might be an eaiser way to do this, but I am in a hurry and have
    > existing queries I need to fix.
    >
    > I have a crosstab query where the column headings are derived from a table.
    > I would rather not have to type in all the values of that table into the IN
    > clause(although there are only 10 or so), since those values might change.
    > Is it possible to use that as a source for the IN statement of the PIVOT
    > clause of my crosstab?
    >
    > Thanks
    > --
    > Fictionally Yours, Biggles
     
    Guest, Feb 8, 2007
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Tom

    To crosstab or not to crosstab ... That is the question

    Tom, Sep 8, 2003, in forum: Microsoft Access Queries
    Replies:
    1
    Views:
    310
    Duane Hookom
    Sep 9, 2003
  2. joshblair
    Replies:
    5
    Views:
    1,981
    Guest
    Jan 13, 2006
  3. OMS

    To Crosstab or not to crosstab

    OMS, Oct 27, 2006, in forum: Microsoft Access Queries
    Replies:
    12
    Views:
    372
  4. alison.justice

    Crosstab query - want report to look like crosstab

    alison.justice, May 30, 2009, in forum: Microsoft Access Queries
    Replies:
    1
    Views:
    499
    KARL DEWEY
    May 31, 2009
  5. Iram
    Replies:
    7
    Views:
    529
Loading...

Share This Page