How do I run this in MS Access
Posted on 2004-09-02
I want to run this query in MS Access. How can I get it to run?
SELECT Count(SN.CASE_ID), Sum(sn.AMOUNT)
FROM SUBRO.SUBRO_CASE sc, SUBRO.SUBRO_NEGOTIATION SN, SUBRO.SUBRO_CASE_CLIENT sccl
Where sccl.CLIENT_ID < 76
and sccl.client_id Not In (49, 56, 58, 59, 69, 71, 72)
AND sc.CASE_STATUS_ID In (2,6)
AND sn.CASE_ID = sc.case_id
And sn.CASE_ID Not In (select case_id from subro.subro_payment where active_ind = 'Y')
AND sccl.CASE_ID = sn.case_id
and sn.entered_dt < '31-jul-04'
I want that last line (sn.entered_dt < '31-jul-04') to pull the date from a form, and not need to be manually entered. I've been dinking with this for a few days now, and I can never get Access to give me the same results that I get with the above SQL.
HELP!!! Please :)