Count IIf Function in Report (1 Viewer)

[Pat Hartman]

1. You do not enclose variable or field names in pound signs. They are ONLY used to enclose literal dates. #05/18/2024#
2. You cannot reference variable names in the ControlSource. You can only reference controls or functions or prompt.
3. You got that answer back in #8

 

[JithuAccess]

1. You do not enclose variable or field names in pound signs. They are ONLY used to enclose literal dates. #05/18/2024#
2. You cannot reference variable names in the ControlSource. You can only reference controls or functions or prompt.
3. You got that answer back in #8

Thank you so much. I have changed my code in the Control Source of my Text box as

=DCount("*","tblFIleRequestData","FIle_Requested_Date BETWEEN  [Forms]![frmReturnedFileStatusInput]![txtBeginDateFIlesReturned] AND[Forms]![frmReturnedFileStatusInput]![txtEndDateFIlesReturned]")

And it works.

Thank you so much

 

[Pat Hartman]

You're welcome. It was a group effort