Prob... please Help.... KRISH

[Guest]

Hi!
Anybody help for the following:
I am working on computerising Guest House Booking procedure. In a particular
month there is one one person booked from say 1-1-2006 to 1-5-2006
(mm-dd-yyyy). Now if I want to design a report for January. My report should
show no of beds booked on all days i.e. from 1st day to 31 days. How to build
a query to solve the problem. Please help.
thanks
Krish

 

[RobFMS]

Homework/Classword??

Here's the date functionality to count the number of days: DateDiff("d",
"1/6/2006", "1/15/2006") + 1
From there, just count the number of people.


--
Rob Mastrostefano

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com