I have no idea why I keep getting this error message so I hope that you guys can help.
When I make a query to group by a month I get the following message:
"This function is not available in expressions"
THe SQL I use is:
SELECT DISTINCTROW Format$([tblMelding].[Datum_nu],"mmmm yyyy") AS [Datum_nu per maand], Sum(tblMelding.DomeinID) AS [Som Van DomeinID]
GROUP BY Format$([tblMelding].[Datum_nu],"mmmm yyyy"), Year([tblMelding].[Datum_nu])*12+DatePart("m",[tblMelding].[Datum_nu])-1;
Am I doing something wrong? Maybe a setting somewhere?
I tried exporting some tables to a new (clean) db and the queries worked like a charm. I dont know what or why. Do you think I should export all the tables and forms etc. to this new db or will the same problem arise?