First of all hello to evryone. I am new on forum and with access as well so sorry if make same funny questions. I have one problem an its related to Sum and group by functions. I have table with four columns and one of them is date. What i need to do is to make querie with sum on one of the column. The problem is when i put sama date range i am not able to get sum just seprated values. I think that you already have picture of what is the problem so i would be very greatfull if you guy and girls help me. Here is also sql view of querie
SELECT Osnovna.Registration, Osnovna.Date, Osnovna.RegionalCenter, Sum(Osnovna.Fuel) AS SumOfFuel
FROM Osnovna
GROUP BY Osnovna.Registration, Osnovna.Date, Osnovna.RegionalCenter, Forms!forma!Date, Forms!forma!Date1
HAVING (((Osnovna.Date)>=[Forms]![forma]![Date] And (Osnovna.Date)<=[Forms]![forma]![Date1])) OR (((Osnovna.Date)<=[Forms]![forma]![Date1]) AND (([Forms]![forma]![Date]) Is Null)) OR ((([Forms]![forma]![Date1]) Is Null));
Thank you very much