Gruppere paa maaneder,,

GROUP BY MONTH(DateFieldGoeHere)

and maybe it was an idea to group on year too

SELECT VareRegistrering.L_Firmanavn, VareRegistrering.Nettovaegt, VareRegistrering.Vo_Dato
FROM VareRegistrering
WHERE ((VareRegistrering.Va_Varenavn)="Slóg")
GROUP BY MONTH(Vo_Dato);


This gives me a fail

som hvilekn type er vo_dato gemt i databasen ?

as bauerdata indicates Vo_Dato should be a datetime data type, and I would also suggest that you first try without the WHERE, or at least try altering it to

SELECT VareRegistrering.L_Firmanavn, VareRegistrering.Nettovaegt, VareRegistrering.Vo_Dato
FROM VareRegistrering
WHERE ((VareRegistrering.Va_Varenavn)='Slóg')
GROUP BY MONTH(Vo_Dato);

..

feltet er af typen datetime

fejlen siger
You tried to execute a query that does not include the specified expression L_Firmanavn as part of an aggregate function

Sorry, you oviously need to group on the other field too. Or use another aggregate function (SUM, COUNT ...).

If you use enterprise manager then you can make a new VIEW which allows you to build your SQL visually

..aggregate function (MIN, MAX, COUNT ...). not Sum

status?