DateValue Function help please

W

wendywi

I am trying to convert a field from text to a date and use it in a parameter
query. It is telling me that the data is too complex to evaluate. I used
the same code in a different query and it worked there. What am I doing
wrong? Basically the user keys in the input into a form and then selects the
query he/she wants. Here is the sql:

SELECT DMSLCOMM_COMMN_STMT_DETL.AOR_SYS_ASSGN_NBR AS [AOR SAN],
DMSLCOMM_COMMN_STMT_DETL.WA_SYS_ASSGN_NBR AS [WA SAN],
DMSLCOMM_COMMN_STMT_DETL.GROUP_NBR, DMSLCOMM_COMMN_STMT_DETL.COMMN_RUN_DT,
DateValue([TXN_DUE_DT]) AS TxnDueDate, DMSLCOMM_COMMN_STMT_DETL.TXN_TYPE_CD,
DMSLCOMM_COMMN_STMT_DETL.TXN_PREM_AMT AS PREMIUM,
DMSLCOMM_COMMN_STMT_DETL.TXN_PAID_AMT AS COMM
FROM DMSLCOMM_COMMN_STMT_DETL
WHERE
(((DMSLCOMM_COMMN_STMT_DETL.AOR_SYS_ASSGN_NBR)=[Forms]![StAuditInput]![AORSAN])
AND ((DateValue([TXN_DUE_DT])) Between [Forms]![StAuditInput]![AORSTART] And
[Forms]![StAuditInput]![AOREND]));

Any help would be appreciated.

Thanks - Wendy
 
Top