Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jbs001

    Help Needed with Analysis of Date Ranges

    Thanks. That pretty much worked after a bit of tinkering. I have got the answer now on a crosstab query but I need to total the columns to get it finished - how do you do that? Thanks for your help so far. Much appreciated. Merry Christmas.
  2. jbs001

    Help Needed with Analysis of Date Ranges

    The 'between' criteria will return the correct number of days in a range - no problem. The question I want the system to answer is "If room A is booked from (in US format)#01/28/07# to #02/05/07#, how many days are in January and how many in February?" The 'between' criteria suggested just...
  3. jbs001

    Help Needed with Analysis of Date Ranges

    I am working on a hotel booking system using MS Access. The room bookings are logged in the database as "from" and "to" dates. I need to write a report which shows, for each room, how many days have been booked in each month. I can't get this to work when the "from" and "to" dates cross over...

Part and Inventory Search

Back
Top