Building an Expression, Date Range, Parameters.
Windows 7 64bit 
Access 2010 64bit
I posted the sample Database
What I want to see, is that if a user enters 2 dates. Example: 01/12/2004 to 06/12/2004, a report, or query will show a list of rooms that were rented for each date on, between and including the dates entered.
So:
Room _____ 01/12/2004 _____02/12/2004_____03/12/2004_____04/12/2004_____05/12/2004
"Name" Then in these columns for it to return some sort of indication, Yes for example it was rented on the above date. Then I can total the number of Yes's and multiply it by the daily rate. I'd like to do this for whatever date range the user enters, whether it's 1 day, or 30 days, or whatever. I'm stuck because my table only has arrival and departure date, and doesn't specify EACH date.... is that more clear?
Reply With Quote
