Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cross-tab Query source problem (Access2000)

    I

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Cross-tab Query source problem (Access2000)

    In your last line of the query, you need something like this to specify each of the possible funds. Of course, this "hardcoding" of the query means that if you change the name of any fund or add new funds, the query must also be modified.

    PIVOT qryReportSource.fund in ("Fund 1", "Fund 2", ...,"Fund 8");
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cross-tab Query source problem (Access2000)

    Thanx alot Mark!
    That works perfectly fine.
    <img src=/S/bow.gif border=0 alt=bow width=15 height=15> <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

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