help with coding please

[alexandervj]

I want to write a code for a calculated text field in a datasheet. Right now the calculated text field is just set to ="view runs" but I want it to say "0 runs" if there are no runs in that Lot (for every lot there could be 0 to many runs). Im not sure how to make my IIf statement... every run has a runID and LotID_FK which is the LotID foregin key which is where the LotID is assigned.

[Xipooo]

You can use the Nz function with the count function:

=Nz(count([runID])) & " runs"

[ItsMe]

..I want to write a code for a calculated text field in a datasheet..

I don't think unbound controls work so swell in datasheet view.