OctaFish
Verenigingslid
- Lid geworden
- 6 feb 2009
- Berichten
- 42.075
Dat kan met deze query:
SELECT [ANALYISIS PRICES 3].[Analysed Date], [ANALYISIS PRICES 3].[Extraction Date], [ANALYISIS PRICES 3].[Day of the Week], [ANALYISIS PRICES 3].[Hotel Emperatriz], [ANALYISIS PRICES 3].[Gran Hotel Velazquez], [ANALYISIS PRICES 3].[Hotel Bauza], [ANALYISIS PRICES 3].Cuzco, [ANALYISIS PRICES 3].[Petit Palace Embassy], [ANALYISIS PRICES 3].[Melia Castilla], [ANALYISIS PRICES 3].[Melia Galgos], [ANALYISIS PRICES 3].[Nh Abascal], IIf([Hotel Emperatriz] Is Null,1,0)+IIf([Gran Hotel Velazquez] Is Null,1,0)+IIf([Hotel Bauza] Is Null,1,0)+IIf([Cuzco] Is Null,1,0)+IIf([Petit Palace Embassy] Is Null,1,0)+IIf([Melia Castilla] Is Null,1,0)+IIf([Melia Galgos] Is Null,1,0)+IIf([Nh Abascal] Is Null,1,0) AS Gesloten, (IIf([Hotel Emperatriz] Is Null,0,[Hotel Emperatriz])+IIf([Gran Hotel Velazquez] Is Null,0,[Gran Hotel Velazquez])+IIf([Hotel Bauza] Is Null,0,[Hotel Bauza])+IIf([Cuzco] Is Null,0,[Cuzco])+IIf([Petit Palace Embassy] Is Null,0,[Petit Palace Embassy])+IIf([Melia Castilla] Is Null,0,[Melia Castilla])+IIf([Melia Galgos] Is Null,0,[Melia Galgos])+IIf([Nh Abascal] Is Null,0,[Nh Abascal]))/(8-[Gesloten]) AS Prijs
FROM [ANALYISIS PRICES 3]
GROUP BY [ANALYISIS PRICES 3].[Analysed Date], [ANALYISIS PRICES 3].[Extraction Date], [ANALYISIS PRICES 3].[Day of the Week], [ANALYISIS PRICES 3].[Hotel Emperatriz], [ANALYISIS PRICES 3].[Gran Hotel Velazquez], [ANALYISIS PRICES 3].[Hotel Bauza], [ANALYISIS PRICES 3].Cuzco, [ANALYISIS PRICES 3].[Petit Palace Embassy], [ANALYISIS PRICES 3].[Melia Castilla], [ANALYISIS PRICES 3].[Melia Galgos], [ANALYISIS PRICES 3].[Nh Abascal];