Greetings,

i have a few querries like the one below.

SELECT [Statistics].[Year], [Statistics].[RoomType],
SUM([Preis]*[Tage])/SUM([Tage]) AS [Avg Of Preis]
FROM Statistics
WHERE [Statistics].[RoomType]='4'
GROUP BY [Statistics].[Year], [Statistics].[RoomType]
ORDER BY [Statistics].[RoomType];

how can I get an output for the field
SUM([Preis]*[Tage])/SUM([Tage]) AS [Avg Of Preis]
as an international format 00.00 (only 2 numbers after the decimalpoint?) in the moment I get n numbers after the DP

many thanks
Manfred