If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
If then Rule
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 |
#2
|
|||
|
|||
If then Rule
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 "SpottedOrange" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|