Hey guys!,
I need a little help and was hoping someone could assist. We are tracking our employees attendance at work, and I built an access database that pulls from our time keeping system however on some instances its pulling the wrong data because a different record is present besides there "Regular Hours". In the picture attached as an example basically what I need to do is for May 4th If Regular Hours is the PAYCODENAME then it needs to disregard any other coding. In this case Unpaid ESA - Family Emergency should not show when I run this query since Regular Hours is present for the same date. I have tried a few IIf statement but I can't seem to get it to work.
Thanks!
I need a little help and was hoping someone could assist. We are tracking our employees attendance at work, and I built an access database that pulls from our time keeping system however on some instances its pulling the wrong data because a different record is present besides there "Regular Hours". In the picture attached as an example basically what I need to do is for May 4th If Regular Hours is the PAYCODENAME then it needs to disregard any other coding. In this case Unpaid ESA - Family Emergency should not show when I run this query since Regular Hours is present for the same date. I have tried a few IIf statement but I can't seem to get it to work.
Thanks!