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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by JackDani

  1. JackDani

    Counting and distributing absence days that span over months

    I have an absence database which records the first day ([startdate]) and the last day ([enddate]) of an absence. I am able to count the length of the absence in days between these 2 dates ([nofda]) , having holidays and weekends discounted so we are left with just the workdays value. Now I...
  2. JackDani

    Form Filters and date ranges

    Hi JB, many thanks again for your help. If I enter a start and end date, then select 'Bulding Services' on the combo box (or any other criteria in the header) and hit submit, the date period is picked up by your excellent coding and captures the dates, but the form seems to ignore the...
  3. JackDani

    Form Filters and date ranges

    Hey JB, many thanks for your response and solution! I've placed your code into my form but Access is popping up a syntax error (missing operator) in query or expression '(isdate[startdate]) AND isnull (enddate]) OR ([enddate] Between AND )' If you get a chance to take a look I have attached...
  4. JackDani

    Form Filters and date ranges

    My form has a series of text/combo boxes that allows filtering of staff records on criteria such as name, department, the first day of absence, the last day of absence, reason for absence and so on. I need to be able to show the absences for a department during a monthly period. I can set the...
See more

Part and Inventory Search

Back
Top