Search results

I have been trying to use on the attached. Columns D and E are the columns I am trying to get access to replicate with queries.

The table in access is linked to an excel spreadsheet however I'm building the calculations in access. I have checked the date format and all is set to date, there is also no blanks in my date columns but I'm still getting the error.

This is the formatting on the spreadsheet. Would access automatically use a different format?

Hi, Thanks for the above. I seem to be getting an error message on the 'Data type mismatch in criteria expression' which i believe is on the date format section of the code. My dates are in UK format of dd/mm/yyyy. I have tried changing the format to this however it still doesn't work. Am I...

Morning CJ Apologies but I think I may be confusing matters. The reason I wanted the results to look like my table is because I want to be able to filter in the final column so I can keep sight of the absence dates that have made the employee hit the trigger. If I input the query as you have...

Hello linxpatrick. I am not trying to calculate lengths of absences, I am trying to calculate how many consecutive months an employee has had time off. The module that /arnelgp has kindly provided does do this accurately. The next step I require however is to be able to work out the max...

Hello, Thank you for the reply. Your database is showing the absence as cumulative and therefore showing ID 3333 as having 4 months. I require it to count the consecutive months and therefore 3 should only have a max of 2.

Hi. To answer your questions: 1 - If there was another absence in May this would just need to be included to be 5 consecutive months. We require everyone with 4 or more consecutive months so there is no need to split into two separate 4 month blocks. 2 - The months just need to start from...

Hello all. I wondered if someone may be able to help me with something I am struggling to do. I have a table to data containing absence dates. I need to be able to work out the people with absences in 4 or more consecutive months. Some absences will span over more than one month so need to be...

Hello all. I’m Dawn and I work in HR. I am fairly new to access although have a lot experience with formulas, coding etc. Live in UK.