Anyone saw this error before??

  • Thread starter Thread starter Pedro
  • Start date Start date
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?
Tks in advance
Pedro
 
Tks for your answer Cheryl. Here it goes :

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;

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...
 
Back
Top