Show bookings staying today from Checkin & CheckOut dates

[FAB1]

Hi

First timer question

After searching for Nemours combinations I am now asking for some help

I have tried combinations to get a expression to give me a list of bookings staying tonight

The fields in the table I use to store the Start & End date of the booking are below
[CheckInDate]
[CheckOutDate]

I have lost my way with Between And <= etc

A wee pointer would be appreciated

Thanks

 

[pbaldy]

How about

WHERE [CheckInDate]<= Date() AND [CheckOutDate] > Date()

 

[FAB1]

Hello and thanks for the quick reply

works a dream

thanks again