Debug DCount in Access/SQL

$10-30 AUD

Selesai

Dibuat

hampir 10 tahun yang lalu

$10-30 AUD

Dibayar ketika dikirim

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.

Microsoft Access

SQL

ID Proyek: 6046100

Tentang proyek

2 proposal

Proyek remot

Aktif 10 tahun yang lalu

Ingin menghasilkan uang?

Alamat email

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda

Dapatkan bayaran atas pekerjaan Anda

Uraikan proposal Anda

Gratis mendaftar dan menawar pekerjaan

Diberikan kepada:

@HossamElDine

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 dalam 0 hari