Group by - uge, kvartal, år

Hej Petersen7913
Legede lige lidt med dit issue. Og hvis jeg skulle hente antal registreringer i min log tabel ud pr uge ville min sql se sådan her ud. Måske du kan tilpasse den lidt så den passer til dit behov.
Håber det kan hjælpe lidt.

SELECT COUNT(*) AS 'antal',
      str_to_date(CONCAT(yearweek(`Tidspunkt`), ' monday'), '%X%V %W') AS `date`
from tb_Log
group by yearweek(Tidspunkt)
ORDER BY Tidspunkt DESC

Not sure if there is a yearweek function in SQL Server but you can maybe use
datepart function

https://docs.microsoft.com/en-us/sql/t-sql/functions/datepart-transact-sql

and you can use datepart to find "kvartal" too

Terry - tak :) Som sædvanligt ;)

selv tak, you not working with Access anymore?

No - Now I doing MS SQL. But SQL is SQL ;) Fixing errors and devolping in old, complex, non-documentet code = interesting ....

yes it sound very interesting. Lots of other more advanced possibilities with SQL server too ;-)