I have a query question. I have a database for employee time attendance. I have a field call "Leave" for VL(vacation leave), SL(sick Leave) such. sometimes employee would like to take half day of sick to vacation. so we store in the table as VL, SL, 1/2 SL pm, 1/2 VL am, AWOP etc. I would like to have a query to pull all employees leave by date but only show 1/2 am or 1/2 pm instead 1/2 SL PM or 1/2 VL am. is this possible?
The pm, it store under the field Time not under the field Leave. so it combine with Leave & Time for VL, 1/2 VL Am like that
here is my query but it shows all not part of them
Expr1: [Leave] & " " & [Time] - result is 1/2 VL am, 1/2 SL PM
Expr2: Left(Trim([Leave]),Len(Trim([Leave]))) it came out same result as the Expr1