Access Instead of 31 rows for March, the view shows 62 records....

Joined
Feb 21, 2018
Messages
216
Reaction score
86
Hi,
I created a view in MS Access 2007...it is supposed to show 31 rows it is showing 62 records...
Please help....
the view's code is as follows

SELECT Voucher.EmpCode, Emp.Name, Voucher.VType, Voucher.PayMonth, Attend.Abs_tag, Attend.Day, Attend.DoW, Attend.Shift, Attend.Time_in, Attend.Time_out, Attend.OT, Attend.Rate, Attend.Amt, Attend.Half_Day, Attend.Late, Attend.Ded, Attend.Vno
FROM (Emp INNER JOIN Voucher ON Emp.EmpCode = Voucher.EmpCode) INNER JOIN Attend ON Voucher.ID = Attend.Vno
WHERE (((Voucher.VType)='O') AND ((Voucher.PayMonth)="MAR-2018") AND ((Attend.Vno) In (select vno from attend where instr(1,half_day,'day'))))
ORDER BY Attend.Day;
 
Back
Top