SELECT FileNo, ReqControlNo, Requester, ReqDate, IssueDate, DueDate, RequesterDeptt, Remarks, HandOverTo, RecordType, ReceivedDate, ProjectName,
ReceivedRemarks, IssueTime, ReceiveTime
FROM Issue
WHERE (format(IssueDate, 'dd-mm-yyyy') BETWEEN format(?, 'dd-mm-yyyy') AND format(?, 'dd-mm-yyyy')) OR
(format(ReceivedDate, 'dd-mm-yyyy') BETWEEN format(?, 'dd-mm-yyyy') AND format(?, 'dd-mm-yyyy'))
ORDER BY ReceivedDate
It returns 677 results.
SELECT FileNo, ReqControlNo, Requester, ReqDate, IssueDate, DueDate, RequesterDeptt, Remarks, HandOverTo, RecordType, ProjectName,
IssueTime From Issue
WHERE (format(IssueDate, 'dd-mm-yyyy') BETWEEN format(?, 'dd-mm-yyyy')
it returns 362 results.
SELECT FileNo, ReqControlNo, Requester, ReqDate, IssueDate, DueDate, RequesterDeptt, Remarks, HandOverTo, RecordType, ReceivedDate, ProjectName,
ReceivedRemarks, IssueTime, ReceiveTime
FROM Issue
WHERE ( (format(ReceivedDate, 'dd-mm-yyyy') BETWEEN format(?, 'dd-mm-yyyy') AND format(?, 'dd-mm-yyyy'))
it returns 338 results.
why Query1 result !=Query2+query3 results.
it's very urgent.
help me!
Problem is that the
first query is not include those files that are issued and received same day.
Update from OP: I got the solution.It's my conceptual mistake.