Croos table Query Prob (1 Viewer)

D

diafis

Guest
Hi
i need somme help to resolve my Crosstable query . i want from my query to display me the state of each room (o or X),,, between the arrival date and the departure date ....
i have two table : Room..and reservation
on my cross table i have on the X axes the room number , and on the Y axes the date (arrival +30 days)
2 3 4 5 ( Arrivale date +30 days)
Ch 10 R R R
ch 12 O O
Ch 13

TRANSFORM First(IIf([Reservation]![StateRoom]="check in","O","")) AS Expr2
SELECT Room_Number.[Room Number]
FROM Room_Numbers LEFT JOIN Reservation ON Room_Number.[Room Number] = Reservation.RoomId
GROUP BY Room_Number.[Room Number]
ORDER BY Room_Numbers.[Room Number], DatePart("d",[Reservation]![Départur])
PIVOT DatePart("d",[Reservation]![arrivale]) In (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31);:what

.. Tx
 

Users who are viewing this thread

Top Bottom