Search results

ok, let's analyse this SELECT MAGACIN.GBR, Sum(MAGACIN.KOL) AS SumOfKOL FROM MAGACIN WHERE (((MAGACIN.DATA) Between #10/1/2011# And #10/31/2011#)) GROUP BY MAGACIN.GBR HAVING (((MAGACIN.GBR)>='1002' And (MAGACIN.GBR)<='1080')); this returns 1202 in SumOfKol instead of 1241, for gbr=1002...

here is my table MAGACIN GBR DATA SIFRA IME KOL 1001 18.10.2011 0991000 DIZEL GORIVO 45 1001 18.10.2011 0991000 DIZEL GORIVO 55 1001 21.10.2011 0992201 AD-BLU 12 1001 22.10.2011 0991000 DIZEL...