C
Clare Lynott
My question is to James A. Fortune: Like Mike I have been searching for a
way to count occurrences for time off benefits. I found your response and
expression in my search and tried it in my database. First I would like to
say thanks because this is leading me in the right direction, but after
duplicating your query using my actual table I came up with some strange
results. After looking it over it seems that everytime there is a weekend,
it is being counted as a new occurrence. Is my assumption correct, if so is
there a way to merge these occurrences over weekends since we do not work
weekends?
way to count occurrences for time off benefits. I found your response and
expression in my search and tried it in my database. First I would like to
say thanks because this is leading me in the right direction, but after
duplicating your query using my actual table I came up with some strange
results. After looking it over it seems that everytime there is a weekend,
it is being counted as a new occurrence. Is my assumption correct, if so is
there a way to merge these occurrences over weekends since we do not work
weekends?