DCount Error

[Marshall Barton]

I have this DCount on a Report Header it pulls the Dates from 2 fields
on a form. I'm getting an #Error....

=Nz(DCount("CheckID","tblChecks","ChkBizDay

You need to use complete comparisons:

=Nz(DCount("CheckID","tblChecks",
"ChkBizDay >= Forms!frmReportDates!TxtStart
AND ChkBizDay <= Forms!frmReportDates!TxtEnd"), 0)

Or use the Between operator:

=Nz(DCount("CheckID","tblChecks",
"ChkBizDay BETWEEN Forms!frmReportDates!TxtStart
AND Forms!frmReportDates!TxtEnd"), 0)

 

[fredg]

Sorry Inaccurate DCount,
Here is the corrected version....

=Nz(DCount("CheckID","tblChecks","ChkBizDay >=
Forms!frmReportDates!TxtStart AND <= Forms!frmReportDates!TxtEnd AND
PAID=-1&"),0)

Still doesn't work!
Thanks,
DS

Is ChkBizDay a Date datatype?
You need to repeat the criteria field for each criteria as well as
surround the variable value with the date delimiter symbol "#".

=Nz(DCount("*","tblChecks","[ChkBizDay] >= #" &
Forms!frmReportDates!TxtStart & "# AND [ChkBizDay] <= #" &
Forms!frmReportDates!TxtEnd & " AND PAID=-1"),0)

Also make sure the name of the control is not the same as the name of
any field used in the control source expression. The form must also be
open when the report is run.

 

[DS]

I have this DCount on a Report Header it pulls the Dates from 2 fields
on a form. I'm getting an #Error....

=Nz(DCount("CheckID","tblChecks","ChkBizDay

=Forms!frmReportDates!TxtStart AND <=Forms!frmReportDates!TxtEnd"),0)

Any Help is appreciated.
Thanks
DS

 

[DS]

I have this DCount on a Report Header it pulls the Dates from 2 fields
on a form. I'm getting an #Error....

=Nz(DCount("CheckID","tblChecks","ChkBizDay

Any Help is appreciated.
Thanks
DS

Sorry Inaccurate DCount,
Here is the corrected version....

=Nz(DCount("CheckID","tblChecks","ChkBizDay >=
Forms!frmReportDates!TxtStart AND <= Forms!frmReportDates!TxtEnd AND
PAID=-1&"),0)

Still doesn't work!
Thanks,
DS

 

[DS]

Sorry Inaccurate DCount,
Here is the corrected version....

=Nz(DCount("CheckID","tblChecks","ChkBizDay >=
Forms!frmReportDates!TxtStart AND <= Forms!frmReportDates!TxtEnd AND
PAID=-1&"),0)

Still doesn't work!
Thanks,
DS

Is ChkBizDay a Date datatype?
You need to repeat the criteria field for each criteria as well as
surround the variable value with the date delimiter symbol "#".

=Nz(DCount("*","tblChecks","[ChkBizDay] >= #" &
Forms!frmReportDates!TxtStart & "# AND [ChkBizDay] <= #" &
Forms!frmReportDates!TxtEnd & " AND PAID=-1"),0)

Also make sure the name of the control is not the same as the name of
any field used in the control source expression. The form must also be
open when the report is run.

Got a Syntax Error
So I did this, Then got "Cancelled previous operation.

=Nz(DCount("*","tblChecks","[ChkBizDay] >= #" &
Forms!frmReportDates!TxtStart & "# AND [ChkBizDay] <= #" &
Forms!frmReportDates!TxtEnd & "# AND PAID=-1"),0)

Thanks
DS

 

[DS]

DS wrote:





You need to use complete comparisons:

=Nz(DCount("CheckID","tblChecks",
"ChkBizDay >= Forms!frmReportDates!TxtStart
AND ChkBizDay <= Forms!frmReportDates!TxtEnd"), 0)

Or use the Between operator:

=Nz(DCount("CheckID","tblChecks",
"ChkBizDay BETWEEN Forms!frmReportDates!TxtStart
AND Forms!frmReportDates!TxtEnd"), 0)

It works! I just can't seem to get the ChkPaid=-1 added though. When I
add it I et an Error!
Thanks
DS

 

[DS]

It works! I just can't seem to get the ChkPaid=-1 added though. When I
add it I et an Error!
Thanks
DS

Got It!

=Nz(DCount("CheckID","tblChecks",
"ChkBizDay BETWEEN Forms!frmReportDates!TxtStart
AND Forms!frmReportDates!TxtEnd AND ChkPaid=-1"), 0)

Thanks
DS