I have an SQL question you may be able to help me with. I'm looking for a way to create a combo box from which I can select a value (in this case, a date) for my selection criteria. See the SQL below.
SELECT DISTINCT A.INV, A.SCAC, A.[CUST ID], A.[RPT DT], A.[SHIP DATE], A.[INV DATE], A.SHIPPER, A.AGE, A.[BAL AMT]
FROM ACCT AS A
WHERE (((A.[DATE PAID]) Is Null)) AND ((A.[INV DATE]) Between [ENTER 'FROM' DATE] And [ENTER 'TO' DATE]) AND ((A.SCAC) Like [ENTER SCAC])
AND A.[SHIP DATE] > [ENTER 'WHERE SHIP DATE GREATER THAN' DATE]
AND A.AGE = (SELECT MAX(B.AGE)
FROM ACCT B
WHERE B.INV = A.INV)
ORDER BY A.AGE DESC , A.INV;
Instead of having to enter a SHIP DATE, in the clause 'AND A.[SHIP DATE] > [ENTER 'WHERE SHIP DATE GREATER THAN' DATE]',
I would like the SQL to present a combo box of dates from the table to select from.