HELP!!! Query not working anymore when introducing a new criteria (similar with the old ones)

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I made a query with 2 criteria, wich is working very well:
SELECT [stoc1-1].Cod_Material, [stoc1-1].Denumire, [stoc1-1].Dimensiuni,
[stoc1-1].Calitatea, [stoc1-1].[SumOfLungime(m)] AS Lungime,
[stoc1-1].[SumOfCantitate(kg)] AS Cantitate
FROM [Nivel alarma] INNER JOIN [stoc1-1] ON ([Nivel alarma].id_den =
[stoc1-1].ID_den) AND ([Nivel alarma].ID_Dimensiuni =
[stoc1-1].ID_dimensiuni) AND ([Nivel alarma].Cod_calit =
[stoc1-1].Cod_Calit)
GROUP BY [stoc1-1].Cod_Material, [stoc1-1].Denumire, [stoc1-1].Dimensiuni,
[stoc1-1].Calitatea, [stoc1-1].[SumOfLungime(m)],
[stoc1-1].[SumOfCantitate(kg)]
HAVING ((([stoc1-1].[SumOfLungime(m)])<=[LungimeaMinimaAcceptabila])) OR
((([stoc1-1].[SumOfCantitate(kg)])<=[CantitateaMinimaAcceptabila]));

Now, I need to introduce a new criteria. I tried as follows, but now is
doesn't work anymore:

SELECT [stoc1-1].Cod_Material, [stoc1-1].Denumire, [stoc1-1].Dimensiuni,
[stoc1-1].Calitatea, [stoc1-1].[SumOfLungime(m)] AS Lungime,
[stoc1-1].[SumOfCantitate(kg)] AS Cantitate, Sum([stoc1-1].[Numar(buc)]) AS
[SumOfNumar(buc)]
FROM [Nivel alarma] INNER JOIN [stoc1-1] ON ([Nivel alarma].id_den =
[stoc1-1].ID_den) AND ([Nivel alarma].ID_Dimensiuni =
[stoc1-1].ID_dimensiuni) AND ([Nivel alarma].Cod_calit =
[stoc1-1].Cod_Calit)
GROUP BY [stoc1-1].Cod_Material, [stoc1-1].Denumire, [stoc1-1].Dimensiuni,
[stoc1-1].Calitatea, [stoc1-1].[SumOfLungime(m)],
[stoc1-1].[SumOfCantitate(kg)]
HAVING ((([stoc1-1].[SumOfLungime(m)])<=[LungimeaMinimaAcceptabila])) OR
((([stoc1-1].[SumOfCantitate(kg)])<=[CantitateaMinimaAcceptabila])) OR
(((Sum([stoc1-1].[Numar(buc)]))<=[Numarlimita]));

Where is the mistake? How can I make it work?
Please, help!!!
 
At first glance you seem to have to many closing brackets in the query
try

SELECT [stoc1-1].Cod_Material, [stoc1-1].Denumire, [stoc1-1].Dimensiuni,
[stoc1-1].Calitatea, [stoc1-1].[SumOfLungime(m)] AS Lungime,
[stoc1-1].[SumOfCantitate(kg)] AS Cantitate, Sum([stoc1-1].[Numar(buc)]) AS
[SumOfNumar(buc)]
FROM [Nivel alarma] INNER JOIN [stoc1-1] ON ([Nivel alarma].id_den =
[stoc1-1].ID_den) AND ([Nivel alarma].ID_Dimensiuni =
[stoc1-1].ID_dimensiuni) AND ([Nivel alarma].Cod_calit =
[stoc1-1].Cod_Calit)
GROUP BY [stoc1-1].Cod_Material, [stoc1-1].Denumire, [stoc1-1].Dimensiuni,
[stoc1-1].Calitatea, [stoc1-1].[SumOfLungime(m)],
[stoc1-1].[SumOfCantitate(kg)]
HAVING ((([stoc1-1].[SumOfLungime(m)])<=[LungimeaMinimaAcceptabila])) OR
((([stoc1-1].[SumOfCantitate(kg)])<=[CantitateaMinimaAcceptabila])) OR
(((Sum([stoc1-1].[Numar(buc)])<=[Numarlimita]));


good luck,
Dave
 
Back
Top