Find Jobs
Hire Freelancers

Debug DCount in Access/SQL

$10-30 AUD

Completed
Posted almost 10 years ago

$10-30 AUD

Paid on delivery
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.
Project ID: 6046100

About the project

2 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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
User Avatar
Hello Good day I can make this DCount statement working for you. Looking forward to hear from you. Thanks Rinsad
$34 AUD in 1 day
4.9 (28 reviews)
5.1
5.1

About the client

Flag of AUSTRALIA
Australia
5.0
6
Payment method verified
Member since Jan 15, 2008

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.