Search results for query: *

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...

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...

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...

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...