+ Reply to Thread
Results 1 to 3 of 3

Cross qry

  1. #1
    Registered User
    Join Date
    11-26-2010
    Location
    Italia
    MS-Off Ver
    Excel 2003
    Posts
    20

    Cross qry

    Hi,
    I need to export into xls file one activity report with two results (sum pz and count order)
    first time I try a select qry pivot view, but if I export this query the output is total of record and not the table like a pivot table!! (if I export a pdf file the view is perfect but isn't what I'm looking)
    In second time I thought a cross qry... wow, one qry to selec sum another to select count. Now one qry joint first and second cross qry. perfect.
    Perfect?!?!?!?
    The original db is updating by a qry, and now I've a problem.
    How can update automaticaly the select qry (from two cross) for extract all new date range? I need rewrite the query all days???
    To better explain what I need, will find my db example.
    http://www.fcarboni.com/forum/fruits.zip
    it's very appreciate if someone can tell me some ideas.
    Thank in advance

  2. #2
    Registered User
    Join Date
    11-26-2010
    Location
    Italia
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: Cross qry

    Someome think that there is a solution for this problem??
    thank
    Fabrizio

  3. #3
    Registered User
    Join Date
    11-26-2010
    Location
    Italia
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: Cross qry

    Solved.

    Now I export into xls with acCmdPivotTableExportToExcel, one file xls will generate with 2 sheets:
    sheet1 = pivot-table
    sheet2 = all records

    with VBA I copy all the sheet1- cell and paste those into a sheet3, I delete sheet1 and 2, and I've the report!!!! (some formatting cell is appropriate)

    Thank

    Fabrizio

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1