If then Rule

  • Thread starter Thread starter SpottedOrange
  • Start date Start date
S

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
 
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
 
Back
Top