Search results

  1. W

    Count number of work days for each month between a range of Dates

    Hi, I need to be able to count the number of workdays for each month between any given range of dates. Example.... If a date range of [startdate] 23/04/2008 - [enddate] 22/05/2008 I need to know how many workdays there were in April and also May separately. Workdays are Monday - to Friday...
  2. W

    Manipulating Calculated Fields

    I developed a query that calulates when a contract is reviewed i.e 5 weeks and 9 weeks after the commencement date. These are called CDE1 and CDE2. This works well and the CDE1 and CDE2 dates are displayed ok. The query above is: SELECT Contract.ContractNo, Contract.APSNo, Contract.Firstname...
  3. W

    Join Problem

    I have two tables: Hours & Incident Hours HoursDate FacilityCode Hours Incident IncidentDate FacilityCode LTI (Yes/No) field How can I join these two tables on the facilitycode so that they are group together by Month on the Hours Table. In other words I want to display all...
  4. W

    Sorting Date Formats

    I based a query on a date field that I formatted to "mmm,yyyy". When I enter a search date range from eg July,2004 to Sept, 2004 it returns all months starting with "J" to "S" rather than the calendar months. I know that the format function does return a string but how can I change this so that...
Back
Top Bottom