Hello,
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.
Thanks.
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
looking forward to working with you
best regards
hossam
$15 AUD in 0 day
0.0 (0 reviews)
0.0
0.0
2 freelancers are bidding on average $25 AUD for this job