dongdv78 > 25-06-13, 03:20 PM
paulsteigel > 25-06-13, 03:57 PM
SELECT a.ISSUEDID, a.ID, a.COMMUNEID, a.BOOKENTRYDATE, a.BOOKEDID
FROM tbl_BookRecords AS a
WHERE (((a.ISSUEDID) In (SELECT [ISSUEDID]
FROM [tbl_BookRecords] As Tmp
GROUP BY [ISSUEDID]
HAVING Count(*)>1 ))
AND ((a.BOOKENTRYDATE) Between #01/09/1996# And #30/09/1997#))
ORDER BY a.ISSUEDID;