If then Rule

[SpottedOrange]

Hello

I am using access 2003 creating a reports database.

I have 2 columns working with this scenario i need. I have an AGENT column
and a NUMCALLS Column, if the AGENT coulumn is blank i need it to put a 0 in
the NUMCALLS Column. Can anyone tell me how to do this correctly? I have
minumum access experience

 

[Clifford Bass]

Hi,

For a report column, set the number-of-calls text box's Control Source
to "=IIf(IsNull([AGENT]) or [AGENT] = "", 0, [NUMCALLS])", without the quotes.

Clifford Bass