openRS rsRoom, SELECT rmID FROM Rooms WHERE rmName = & Chr$(34) & - TopicsExpress



          

openRS rsRoom, SELECT rmID FROM Rooms WHERE rmName = & Chr$(34) & Me.cmbRoom.Text & Chr$(34), dbOpenSnapshot roomID = rsRoom!rmID closeRs rsRoom openRS rsGuest, SELECT * FROM Accomodation WHERE accID & Val(Me.Tag) & AND rmID = & roomID & AND (( & intArr & VAL(FORMAT(accDtIn,yyyyMMdd))) & OR ( & intArr & < VAL(FORMAT(accDtOut,yyyyMMdd)) AND & intDepa & > VAL(FORMAT(accDtOut,yyyyMMdd))) & OR ( & intArr & < VAL(FORMAT(accDtIn,yyyyMMdd)) AND & intDepa & > VAL(FORMAT(accDtOut,yyyyMMdd))) & OR ( & intArr & >= VAL(FORMAT(accDtIn,yyyyMMdd)) AND & intDepa &
Posted on: Fri, 22 Nov 2013 20:28:38 +0000

Trending Topics



Recently Viewed Topics




© 2015