D
diafi sam via AccessMonster.com
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)
i a looking for a way to put the sate (X or o) between the arrivale and the departure .
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]![D?partLe]) 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 for the Help
*****************************************
* This message was posted via http://www.accessmonster.com
*
* Report SPAM or ABUSE by clicking the following URL:
* http://www.accessmonster.com/Uwe/Abuse.aspx?aid=b1e48f0c1c6e40ef9994225ab9cd9de6
*****************************************
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)
i a looking for a way to put the sate (X or o) between the arrivale and the departure .
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]![D?partLe]) 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 for the Help
*****************************************
* This message was posted via http://www.accessmonster.com
*
* Report SPAM or ABUSE by clicking the following URL:
* http://www.accessmonster.com/Uwe/Abuse.aspx?aid=b1e48f0c1c6e40ef9994225ab9cd9de6
*****************************************