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.
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