Sqlite query

[sigster]

Hi

I am try to change from Microsoft access mdb to sqlite

This is my query to day with mdb database anyone here who can help me so I can use this with sqlite

Dim queryString As String = "TRANSFORM Sum(databasere.total) AS SumOftotal SELECT databasere.Textkey, Sum(databasere.total) AS [totalsum] FROM databasere WHERE YEAR(Date_change) = '" & Cbo_talnng_ar.Text & "' GROUP BY databasere.Textkey ORDER BY databasere.Textkey PIVOT Format([Date_change],""mmm"") In (""jan"", ""feb"", ""mar"", ""apr"", ""maí"", ""jún"", ""júl"", ""ágú"", ""sep"", ""okt"", ""nóv"", ""des"")"

Regards
Sigster

 

[sigster]

Date format in sqlite is 2021-04-15