I have a text box that I am using to run a count on a number of records based on a 30 day date range. The control source is set at below.
=DCount("*","dbo_NonConfData","CaseDate between(Date() -30) and Date()")
When I open the form I receive an Error# in the object or if I make changes, such as placing brackets around [CaseDate] it will show just a zero value
The odd thing is that I have this working on a system running Access 2013. The result displayed on the form is accurate and without error.
My access application's data resides on a sql server. I am using the sql server Native Client 10.0 ODBC driver on the Access 2010 system and on the Access 2013 system I am using the sql server Native Client 11.0 ODBC driver
Can anyone offer a suggestion as to what the difference could be?