Report Reference

[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)

 

[Duane Hookom]

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)

 

[DS]

Thanks Duane, this worked.
=Nz(DCount("CheckID","tblWalkOut","ChkServer= " & [ChkServer]),0)
DS