F
filo666
Hi, I'm having a lot of problems with the following SQL and I dont know Why¡¡¡
SELECT [de 30 a 60 dÃas].Número, sum([de 30 a 60 dÃas].[Total con IVA]) AS
totalconiva, from [de 30 a 60 dÃas], group by [de 30 a 60 dÃas].Vencimiento;
The query name is [de 30 a 60 dÃas]
and I'm trying this:
Vencimiento Total con Iva
12/08/05 2345
12/08/05 6667
12/08/05 1212
13/08/05 4544
13/08/05 444
13/08/05 4598
14/08/05 8789
14/08/05 5656
14/08/05 898
AND SO ON
and I whant this:
12/08/05 10215
13/08/05 7980
14/08/05 17893
And so on until the end of the month where I want to put the Grand Total
When the code is run appears the following message:
"The instruction SELECT includs a reserved word, an argument is missing or
has a spelling mistake, or punctuation signs are incorect (Sorry for the
grammar but it's a traslation from spanish)
What I'm doing wrong????
TIA
SELECT [de 30 a 60 dÃas].Número, sum([de 30 a 60 dÃas].[Total con IVA]) AS
totalconiva, from [de 30 a 60 dÃas], group by [de 30 a 60 dÃas].Vencimiento;
The query name is [de 30 a 60 dÃas]
and I'm trying this:
Vencimiento Total con Iva
12/08/05 2345
12/08/05 6667
12/08/05 1212
13/08/05 4544
13/08/05 444
13/08/05 4598
14/08/05 8789
14/08/05 5656
14/08/05 898
AND SO ON
and I whant this:
12/08/05 10215
13/08/05 7980
14/08/05 17893
And so on until the end of the month where I want to put the Grand Total
When the code is run appears the following message:
"The instruction SELECT includs a reserved word, an argument is missing or
has a spelling mistake, or punctuation signs are incorect (Sorry for the
grammar but it's a traslation from spanish)
What I'm doing wrong????
TIA