Hi everyone,
I have a table with a field named "Date added"
When I try to write the following code:
CNT2 = DCount("*", "ORDERS", "Salesman='" & [Forms]![SALE_REPORT_F]![INIT_IN] & "' And Date added between #" & [Forms]![SALE_REPORT_F]![FROM_IN] & "# AND #" & [Forms]![SALE_REPORT_F]![TO_IN] & "#")
so I get the following error:
Syntax error (missing operator) in query expression 'Saleman='JB' and Date added between #4/1/2004# AND #4/10/2004#
How can I solved this problem without changing the name of the field on the table.
I have a table with a field named "Date added"
When I try to write the following code:
CNT2 = DCount("*", "ORDERS", "Salesman='" & [Forms]![SALE_REPORT_F]![INIT_IN] & "' And Date added between #" & [Forms]![SALE_REPORT_F]![FROM_IN] & "# AND #" & [Forms]![SALE_REPORT_F]![TO_IN] & "#")
so I get the following error:
Syntax error (missing operator) in query expression 'Saleman='JB' and Date added between #4/1/2004# AND #4/10/2004#
How can I solved this problem without changing the name of the field on the table.
