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.

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.