I am creating a report where a print out will show a list of data being sent to each location. Each location has anywhere from 2 to 10 different forms they could receive. WHEN a certain form is sent, it needs to have an "X" mark in a corresponding field showing it was included in the packet.
Here is my question. I am trying to create an IIf statement where an "X" mark becomes visible in a field WHEN the field it is tied to has data. Here is my attempt:
IIf ( [field] = Null Value, " ", "X")
Any ideas?
Brandon
Here is my question. I am trying to create an IIf statement where an "X" mark becomes visible in a field WHEN the field it is tied to has data. Here is my attempt:
IIf ( [field] = Null Value, " ", "X")
Any ideas?
Brandon