Report Reference

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

I have an unbound textbox in a report group footer, it refers to a bound
textbox in the same groups header. It's not returning a value. The report
is called rptFXWalkOut. The field is ChkServer. Any help appreciated.
Thanks
DS

=Nz(DCount("CheckID","tblWalkOut","ChkServer= Report.Report.ChkServer"),0)
 
Is the control named ChkServer or is this the name of the control? Is the
value numeric or text? If it is numeric, you should be able to use:

=Nz(DCount("CheckID","tblWalkOut","ChkServer= " & [ChkServer]),0)

If ChkServer is text, try:
=Nz(DCount("CheckID","tblWalkOut","ChkServer= """ & [ChkServer] & """"),0)
 
Thanks Duane, this worked.
=Nz(DCount("CheckID","tblWalkOut","ChkServer= " & [ChkServer]),0)
DS
 
Back
Top