Search results

It's last thing I have to do to finish my database, so is there anyone here who could help me(yes, I know it's Sunday)?

But for example, during reservation when a guest is choosing a room, how can I for example show in a combo box (or any other way) only free rooms? Because if I create a query, in which I'll add a field from reservation table(date_checkout) and in criteria a <Date() it will only show rooms which...

Any ideas?

Well, basically I'm doing a database for a hotel and I wanted to do an automatic update query to change status(by comparing the dates - whether todays date is after the date of checkout or before) and it's working fine, but when I have two rooms(records) with the same id in Reservation table...

Ok, I think I managed to do it, but it's not really what I wanted it to do, because it only shows one record with the latest date, is there any chance to show all the records, but if for example we have 2 records with the same id, to show only one of them, the one which has the latest date?

Can't you just tell me how should I use it? Because I have no idea... :/

Ok, but where should I use it, because when I try it like that: UPDATE Room INNER JOIN Reservation ON Room.id_p = Reservation.room SET Room.status = "occupied" WHERE (((Room.status)="free") AND ((DMax([Reservation.date_checkout]))>=Date())); there's a "invalid number of parameters" error...

Hi, I tried to get the max date value, but I got an error - Cannot have aggregate function in WHERE clause (((Room.status)="free") AND ((Max([Reservation.date_checkout]))>=Date())); Code: UPDATE Room INNER JOIN Reservation ON Room.id_p = Reservation.room SET Room.status = "occupied" WHERE...