flaviooooo
Programmer
Hi there,
I have this query in Excel 97 (MSQuery). I want to replace the years (2003 and 2002) by a parameter. But when I replace the years in my SQL statement by a '?' or '[Give year]', it gives me the 'Too few Parameters, expected 1' error...
Any ideas?
SELECT Year(DATUM), Month(DATUM), Left(MACHINE,4), Sum(PRODUCTIE.STILNTLHR)
FROM `C:\Nacalculatie`.PRODUCTIE PRODUCTIE
GROUP BY Year(DATUM), Month(DATUM), Left(MACHINE,4), (Year(DATUM)), (Month(DATUM))
HAVING ((Year(DATUM))=2003) AND ((Month(DATUM))<7) AND ((Sum(PRODUCTIE.STILNTLHR))<>0) OR ((Year(DATUM))=2002) AND ((Month(DATUM))>6)
I have this query in Excel 97 (MSQuery). I want to replace the years (2003 and 2002) by a parameter. But when I replace the years in my SQL statement by a '?' or '[Give year]', it gives me the 'Too few Parameters, expected 1' error...
Any ideas?
SELECT Year(DATUM), Month(DATUM), Left(MACHINE,4), Sum(PRODUCTIE.STILNTLHR)
FROM `C:\Nacalculatie`.PRODUCTIE PRODUCTIE
GROUP BY Year(DATUM), Month(DATUM), Left(MACHINE,4), (Year(DATUM)), (Month(DATUM))
HAVING ((Year(DATUM))=2003) AND ((Month(DATUM))<7) AND ((Sum(PRODUCTIE.STILNTLHR))<>0) OR ((Year(DATUM))=2002) AND ((Month(DATUM))>6)