I have a query in Delphi, created with a access table, here is my query.

TRANSFORM Count(Effet.[No]) AS [La valeur]
SELECT Effet.ID, Count(Effet.[No]) AS [Total de No]
FROM Effet
GROUP BY Effet.ID
PIVOT Format([Date],"dddd") In
("dimanche","lundi","mardi","mercredi","jeudi","vendredi","samedi");

Question
Is there a better way to do this with a multi-language application?
How can i found witch language of Access or Windows language are they
use ?

Thank's for any respond.

Luc