I have three tables named Teacher Attendance, Teacher, Teacher Fine
Teacher Attendance table contains the following fields :
Teacher ID
Attendance Date
Status
School Timing
Arrival Time
Late Time Duration
Remarks
Teacher table contains the following fields :
Teacher ID
Teacher Name
Qualification
Class Assigned
Mobile No
Remarks
Inactive
Teacher Fine Table contains the following fields :
Teacher ID
Date
Absent
Late
Inactive
Now I create a Query with Table Teacher and Table Teacher Fine name Query 44 with contains the following fields:
Teacher ID
Teacher Name
Date
Absent
Late
This query works fine
When I Join this Query 44 with Teacher Attendance (only one field from teacher attendance named "Late Time Duration". It returns the duplicate record with the same data
The query expression is as under
SELECT Query44.[Teacher ID], Query44.[T Att ID], Query44.[Teacher Name], Query44.Date, Query44.Absent, Query44.Late, [Teacher Attend].[Late Time Duration], Month([Date]) AS Expr1
FROM Query44, [Teacher Attend]
WHERE (((Month([Date]))=Month(Now())-1));
Anyone help me why the second query returning in duplicate
I will be grateful for this kindness.
Teacher Attendance table contains the following fields :
Teacher ID
Attendance Date
Status
School Timing
Arrival Time
Late Time Duration
Remarks
Teacher table contains the following fields :
Teacher ID
Teacher Name
Qualification
Class Assigned
Mobile No
Remarks
Inactive
Teacher Fine Table contains the following fields :
Teacher ID
Date
Absent
Late
Inactive
Now I create a Query with Table Teacher and Table Teacher Fine name Query 44 with contains the following fields:
Teacher ID
Teacher Name
Date
Absent
Late
This query works fine
When I Join this Query 44 with Teacher Attendance (only one field from teacher attendance named "Late Time Duration". It returns the duplicate record with the same data
The query expression is as under
SELECT Query44.[Teacher ID], Query44.[T Att ID], Query44.[Teacher Name], Query44.Date, Query44.Absent, Query44.Late, [Teacher Attend].[Late Time Duration], Month([Date]) AS Expr1
FROM Query44, [Teacher Attend]
WHERE (((Month([Date]))=Month(Now())-1));
Anyone help me why the second query returning in duplicate
I will be grateful for this kindness.