What could be possibly wrong with an SQL????

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
 
D

Douglas J. Steele

You've got 2 extra commas in your statement: one between totalconiva and
from, and the other between [de 30 a 60 días] and group
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top