I'm looking for someone who can assist me in debugging a particular line DCount statement Access/SQL. I have attached a copy of the DB for reviewing, I believe the issue is with SQL query 'Count'. There are two tables, DaystoCount which lists several date ranges, and DaystoExclude, which lists days that should be skipped from being counted. The SQL query should count the days in DaystoCount except for any days listed in DaystoExclude. However, sometimes when the range in DaystoCount doesn't cross a date in DaystoExclude, it still doesn't count the day.
For example, the current output should display the following:
|7/03/2014 |0 |
|2/05/2014 |1 |
But instead it's displaying:
|7/03/2014 |1 |
|2/05/2014 |0 |
Please give an indication how long you think it will take you rectify this issue.