Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    3

    Question Unanswered: Chart and Report detail don't match

    TRANSFORM Sum(QRY_LECHE.CANTIDAD) AS SumOfCANTIDAD SELECT QRY_LECHE.FECHA_ORDENO FROM QRY_LECHE
    GROUP BY QRY_LECHE.FECHA_ORDENO PIVOT QRY_LECHE.NUMERO_ESTAMPADO;

    Where fecha_ordeno is the rowheading, numero_estampado is columheading and cantidad is the value for the column graph. The graph appears in a report and is suppose to match the current date via a child/master field (fecha_ordeno), but they don't. Instead I get graph of day 5 in day 6, 6 in the 7 and so on. Some times (very few) it appears right.

    The report look like this :

    Fecha : 01/05/2003
    -------------------------------------
    No. Estamp Cantidad
    -------------------------------------
    101 10
    102 20

    Graph :
    ----------------------------------------
    102
    ---
    101 | |
    --- | |
    | | | |
    | | | |
    -----------------------------------------
    01/06/2003

    Note the dates of the graph and the report don't match (but they are linked through the child/master field). How do I make them match.

    !HEEEEEEEEEEEEEEEEEEEEEEEEEELP!

    I don't know what else to do.

  2. #2
    Join Date
    Nov 2003
    Posts
    3

    Re: Chart and Report detail don't match

    Here you have the file. Please set marginst to 0.5", and orientation to Ladscape so it fit.
    Attached Files Attached Files

  3. #3
    Join Date
    Nov 2003
    Posts
    3

    Re: Chart and Report detail don't match

    Originally posted by july_dunlop
    Here you have the file. Please set marginst to 0.5", and orientation to Ladscape so it fit.
    This a microsoft documented behavior is caused by a timing problem between Microsoft Access and Microsoft Graph. To find out more look for :
    318079 For Access 2000
    317155 For Access 997
    318096 For Access 2002

    They have 2 methods to work around.

Posting Permissions

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