Anyone saw this error before??

P

Pedro

Here's a tuff one
I have a qry that runs perfectly on a report. It has
parameters like month and year. The report under that
qry works perfectly till the month of October. When i ask
in Parameters 11-2003 or 12-2003 it doesn't work. But if i
ask any other month it works very well. That qry works
for any periode. The message that appears after selecting
11-2003 is : The Microsoft Jet Database engine does not
recognize " as a valid field name or expression.
Weird no? I've delete that report and did another and
still the same result.
Any suggestions, please?
Here goes the code

PARAMETERS Data DateTime;
TRANSFORM Sum(Query1.Total) AS SumOfTotal
SELECT Query1.Mês, Query1.Nome, Query1.Grupo, Query1.[C
Custo], Sum(Query1.Total) AS [Total Of Total]
FROM Query1
WHERE (((Query1.Mês)=[Data]))
GROUP BY Query1.Mês, Query1.Nome, Query1.Grupo, Query1.[C
Custo]
PIVOT Query1.Combustivel;

And the code for query1

SELECT Dados.N_Cartao, Dados.Cod_cartao, Dados.Data,
Dados.Hora, Dados.N_Transac, Dados.Combustivel,
Dados.Litros, Dados.PU, Dados.Total, Dados.Local,
Dados.TRIMESTREE, Dados.Quinzena, [Frota TVI].Matricula,
[Frota TVI].Nome, [Frota TVI].[Plafon Galp], [Frota TVI].
[Nome CCusto], [Frota TVI].Grupo, Dados.Mês, *
FROM Dados LEFT JOIN [Frota TVI] ON Dados.Cod_cartao =
[Frota TVI].C_Cartao;

Please don't forget that works just fine for the other
months...

Tks in advance
Pedro
 
Top