Search results

Should I create 4th Query for Employee_Record? and Then combine sub2, sub3 and Employee_Record Query in 5th Query? I am sorry I am confused. Please guide me.

I've join sub2 to Employee_Record and sub3 to Employee_Record via EmployeeID then change the in the join Property All records from Employee Record. When I am running this Query an error appears. Please check attached screenshots.

I have created sub1, sub2 and sub3 according to your instructions. I got total number of absents of each employee, and total overtime hours for each employee. Its working! Thank you so much. Please guide me which criteria should I add to sub1?

I've created sub1 please check this.

Can you please explain this?

Thank you arnelgp for the response.

Thank you very much dear plog, Let me try this! I'll tell you after completing it successfully.

Thank you very much Ranman

When I am running this query using “Between [Enter Start Date:] And [Enter End Date:]”. Employee name, Designation, Department Attendance status (Including Present, Absent, Sunday, and Other Holiday) is repeating for every date. I need the following output: 1-time Employee Name, Employee ID...

Hi, Gasman Thank you very much for the response. Hide Duplicates properties was "Yes". I've changed it to "No". Issue resolved. Thank you so much for your guidance dear.

Hi, I need help. Some data in the middle of my ms access report (like on 3rd Column and 26, 27, 28 rows) is disappearing in print preview. And not printing. You can check the issue in the screenshot attached with this post. Please guide me how to fix this issue. Thank you very much.

Hello, My name is Muhammad Khurram Shaikh. I am from Pakistan. I am a student of Microsoft Access programming and also using it at my work place. I am "Intermediate Level Access programmer". My hobby is to make useful Microsoft Access programs. :)