D
David8
Hi from Barcelona,
First, sorry for my sintax !!
I've a query i want show in my page, but i can't find the problem !!!!.
SELECT MY_TABLE.Id, MY_TABLE.DIFER, MY_TABLE.fecha, MY_TABLE.TIPODIA,
MY_TABLE.dias, MY_TABLE.mes, [DIFER]*[dias] AS Multiply,
DSum("[dias]*[DIFER]","[MY_TABLE]","[Id] <=" & [Id]) AS CONTINUO,
MY_TABLE.TOTALREAL, MY_TABLE.total FROM MY_TABLE GROUP BY MY_TABLE.Id,
MY_TABLE.DIFER, MY_TABLE.fecha, MY_TABLE.TIPODIA, MY_TABLE.dias,
MY_TABLE.mes, [DIFER]*[dias], MY_TABLE.TOTALREAL, MY_TABLE.total
HAVING (((MY_TABLE.mes)="JAN"));
Help me, thanks.
David8
First, sorry for my sintax !!
I've a query i want show in my page, but i can't find the problem !!!!.
SELECT MY_TABLE.Id, MY_TABLE.DIFER, MY_TABLE.fecha, MY_TABLE.TIPODIA,
MY_TABLE.dias, MY_TABLE.mes, [DIFER]*[dias] AS Multiply,
DSum("[dias]*[DIFER]","[MY_TABLE]","[Id] <=" & [Id]) AS CONTINUO,
MY_TABLE.TOTALREAL, MY_TABLE.total FROM MY_TABLE GROUP BY MY_TABLE.Id,
MY_TABLE.DIFER, MY_TABLE.fecha, MY_TABLE.TIPODIA, MY_TABLE.dias,
MY_TABLE.mes, [DIFER]*[dias], MY_TABLE.TOTALREAL, MY_TABLE.total
HAVING (((MY_TABLE.mes)="JAN"));
Help me, thanks.
David8