Report Reference

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

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

DS

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