Microsoft Access Error 3071

[jessef1980]

I wrote a query that works on some computers but not others. I don't understand why it would do this. Here is the SQL of it


PARAMETERS [Enter Start Date:] DateTime, [Enter End Date:] DateTime;
SELECT Employee.Emp, SYSADM_PRODUCT_SIZE.STYLE, SYSADM_RECEIPT_LINE.QTY, SYSADM_CUSTOMER.LAST_NAME, SYSADM_RECEIPT_LINE.SELLING_PRICE
FROM (((SYSADM_RECEIPT_LINE INNER JOIN SYSADM_PRODUCT_SIZE ON SYSADM_RECEIPT_LINE.SKU = SYSADM_PRODUCT_SIZE.SKU) INNER JOIN Employee ON SYSADM_RECEIPT_LINE.SALES_ASSOCIATE = Employee.SALES_ASSOCIATE) INNER JOIN SYSADM_RECEIPT ON SYSADM_RECEIPT_LINE.RECEIPT_ID = SYSADM_RECEIPT.RECEIPT_ID) INNER JOIN SYSADM_CUSTOMER ON SYSADM_RECEIPT.CUSTOMER_ID = SYSADM_CUSTOMER.CUSTOMER_ID
WHERE (((SYSADM_RECEIPT_LINE.QTY)<>0) AND ((CDate(Left([SYSADM_RECEIPT]![SALES_DATE],10))) Between [Enter Start Date:] And [Enter End Date:]) AND ((SYSADM_RECEIPT_LINE.SALES_CODE)="S") AND ((SYSADM_PRODUCT_SIZE.VENDOR_NO)="31") AND ((SYSADM_RECEIPT_LINE.DEPARTMENT)<>"Misc"))
ORDER BY CDate(Left([SYSADM_RECEIPT]![SALES_DATE],10));


It is a very complex query. I do have two parameters set. Thanks for the help

 

[dhookom]

This question is being addressed in another thread in another TT forum.

Duane
Hook'D on Access
MS Access MVP