3464 mismatch error on Query depending on the number of fields

M

massimo

Hi, I have a query, extracting some detail data.
then. I have a second query, used to group and sum data from the previous one.
If I have three Currency fields used for Sum, the query works, if I add a
fourth fields, I get the 3464 error. If I change the fields selected, the
result doesn't change: if field X is selected as third field, the query
works, if it is selected as fourth, the query abends. The grouping fields
remain the same in the two cases, and the underlying data are unchanged.

Some examples follows: SELECT SS_MensileCdG.mese, SS_MensileCdG.centro,
SS_MensileCdG.idTipoRapporto, SS_MensileCdG.classe,
Sum(SS_MensileCdG.costoAzienda) AS SommaDicostoAzienda,
Sum(SS_MensileCdG.dipOrdinario) AS SommaDidipOrdinario,
Sum(SS_MensileCdG.contributiSuRetribuzione) AS SommaDicontributiSuRetribuzione
FROM SS_MensileCdG
GROUP BY SS_MensileCdG.mese, SS_MensileCdG.centro,
SS_MensileCdG.idTipoRapporto, SS_MensileCdG.classe; <== WORKS

SELECT SS_MensileCdG.mese, SS_MensileCdG.centro,
SS_MensileCdG.idTipoRapporto, SS_MensileCdG.classe,
Sum(SS_MensileCdG.costoAzienda) AS SommaDicostoAzienda,
Sum(SS_MensileCdG.dipOrdinario) AS SommaDidipOrdinario,
Sum(SS_MensileCdG.contributiSuRetribuzione) AS
SommaDicontributiSuRetribuzione, SS_MensileCdG.dipStraordinario
FROM SS_MensileCdG
GROUP BY SS_MensileCdG.mese, SS_MensileCdG.centro,
SS_MensileCdG.idTipoRapporto, SS_MensileCdG.classe,
SS_MensileCdG.dipStraordinario; <=== 3464 ERROR

SELECT SS_MensileCdG.mese, SS_MensileCdG.centro,
SS_MensileCdG.idTipoRapporto, SS_MensileCdG.classe,
Sum(SS_MensileCdG.costoAzienda) AS SommaDicostoAzienda,
Sum(SS_MensileCdG.dipOrdinario) AS SommaDidipOrdinario,
SS_MensileCdG.dipStraordinario
FROM SS_MensileCdG
GROUP BY SS_MensileCdG.mese, SS_MensileCdG.centro,
SS_MensileCdG.idTipoRapporto, SS_MensileCdG.classe,
SS_MensileCdG.dipStraordinario; <=== WORKS

I am really confused!!

Access 2003 SP2 on windows XP !GB Pentium IV box
 
Top