Access Database Help

[ArmoVanBuuren]

Currently making an access hotel booking system and am abit stuck, need to produce a report of the people checking out within 2 days

I have used

DateAdd("d",2,Date())

Which picks up check outs 2days in advance but I cant quite figure out how to do within 2days .

Just wondering how I would do this?

Edit.
have tried put <= but this returns results of past bookings, how can i get it to only display checkouts from today onwards till 2 days have gone?

Edit.

Do I need to compare the value to the date()?

Anyone please?

 

[ArmoVanBuuren]

Not to worry, I solved it in the end by using this code

DateAdd("d",2,Date()) Or DateAdd("d",1,Date()) Or Date()

Abit longer than I expected but it works fine.

 

[Beepcake]

I know you've sorted it; but ff you want to re-visit it, have a look at the datediff function in the help.

 

[ArmoVanBuuren]

Does Anyone how I can compare arrival date with checkout date with date() to only show customers who are stopping at the hotel at the moment?

 

[Beepcake]

Well if DateDiff("d", arrivalDate, date()) was greater than or equal to 0 (or just greater than if you don't want people arriving today) then the customer would have arrived... if DateDiff("d", checkoutDate, date()) was less than or equal to 0 (or just less than if you don't want people checking out today) then the customer hasn't left yet.. combine the two with an AND and you should have people that are currently there.

Had a few drinks, but hopefully that's right

 

[ArmoVanBuuren]

Cheers Beepcake

Is it something like the code below which I cant get to work

SELECT Customer.CustomerID, Customer.FirstName, Customer.Surname, Rooms.RoomNum, Rooms.RoomType, Booking.Arrival, Booking.Checkout
FROM Rooms INNER JOIN (Customer INNER JOIN Booking ON Customer.CustomerID = Booking.CustomerID) ON Rooms.RoomNum = Booking.Room
WHERE (DateDiff("d",Booking.Arrival,Date())>0 And DateDiff("d",Booking.Checkout,Date()) < 0);

 

[ArmoVanBuuren]

Solved it in the end with

SELECT Customer.CustomerID, Customer.FirstName, Customer.Surname, Rooms.RoomNum, Rooms.RoomType, Booking.Arrival, Booking.Checkout
FROM Rooms INNER JOIN (Customer INNER JOIN Booking ON Customer.CustomerID = Booking.CustomerID) ON Rooms.RoomNum = Booking.Room
WHERE (((DateDiff("d",[Arrival],Date()))>0) AND ((DateDiff("d",[Checkout],Date()))<0));

Damn Square Brackets needed for field names in where clause.

 

[sfx]

You could try using:

BETWEEN Date1 AND Date2

Hope this helps.

sfx