Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jan 2002
    Location
    Irvine, California, USA
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Transferring Excel Report to Access (Access 97)

    I have to develop a report in Access that was previously developed in Excel. The Excel report source is a pivot table with 3 rows and 5 columns. The pivot table source is an Access Database. How do I develop a query to mimic the pivot table? I tried the crosstab query, and it states there are too many columns. I have attached a sample of the report in excel.
    Thanks,
    newcomer to Access
    Attached Files Attached Files

  2. #2
    New Lounger
    Join Date
    Nov 2001
    Location
    Virginia
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Transferring Excel Report to Access (Access 97)

    IN queries you need to look at the View/Totals option

    In Reports you need to look at the sorting and grouping options as well as section headers.

    Also, in reports, look into the iif function in conjunction with sum i.e., sum(iif([fieldname])=criteria,1,0))


    HTH.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Transferring Excel Report to Access (Access 97)

    There is a Solutions.mdb database for Access 97 that should have been included with the product and contains an example of an advanced report based on a multiple-fact crosstab query, which sounds like what it you want. MSKB article Q248674 for a link to the Solutions9.mdb download site.
    Charlotte

Posting Permissions

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