Microsft Access Query Help

[rplum]

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






Let me know if you need anything else!


Thanks again

[ranman256]

Its 2 queries, regular:
Q1: select * from table where instr([paycodename],"Regular")>0
and
Q2: select * from table where instr([paycodename],"Overtime")>0

you can then pull them both together in a union query if needed.

[rplum]

That didn't work for me. When I ran those two queries I just got numbers.