Debug DCount in Access/SQL


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:

|NEndDate |ExcludedCount|

|7/03/2014 |0 |

|2/05/2014 |1 |

But instead it's displaying:

|NEndDate |ExcludedCount|

|7/03/2014 |1 |

|2/05/2014 |0 |

Please give an indication how long you think it will take you rectify this issue.


Evner: Microsoft Access, SQL

Se mere: sql microsoft access, microsoft access sql, think debug, sql microsoft, access sql, access sql query, sql query access, sql query date, sql day, access sql count, access day, display range query, can display date range query, display query range, copy sql, access day query, data access layer business object code example net, sql access desde asp, sql access filtering, convert text file html vba sql access, fusion sql access, vbnet choose sql access, vba sql access, viewing report sql access, convert sql access vba

Om arbejdsgiveren:
( 6 bedømmelser ) Australia

Projekt ID: #6046100

Tildelt til:


Hello I found the problem Message me with your mail So i send you snap shoot of the BD working correctly I chose the lowest fee as its too simple my main purpose is your satisfaction and my feedback look Flere

$15 AUD in 0 dage
(0 bedømmelser)

2 freelancere byder i gennemsnit $25 på dette job


Hello Good day I can make this DCount statement working for you. Looking forward to hear from you. Thanks Rinsad

$34 AUD på 1 dag
(28 bedømmelser)

PHP [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] http://sneakysbarwood Flere

$25 AUD in 15 dage
(0 bedømmelser)