Adding if statement

[bradp1979]

I think I may have asked this, but I don't remember if I did, and if I did, whether I did so correctly. So here we go again:

Below is qrySERS. For events where the EntityName is an individual insteady of a company, it just comes back blank. So I need to add a statement to the highlighted cell that basically says "use EntityName. if is null EntityName, then use ClientName".



I just don't know the proper wording.

Thanks!

[orange]

You could try this:

ThingName: IIF(IsNull(EntityName),ClientName,EntityName)

[June7]

If using IsNull, might as well use Nz:

Nz(EntityName, ClientName)

http://allenbrowne.com/QueryPerfIssue.html

[InsuranceGuy]

Both solutions will work, but both call VBA. As our Dear Allen Brown points out, you're better off using JET comparisons for speed.

=IIF(EntityName is null, ClientName, EntityName)

Cheers,

Jeff

[bradp1979]

Oddly enough, it's still not working. I tried both suggestions above by June and orange. Can I put the if statement directly in the text box, or does it have to be in the query?

[June7]

Certainly can.

What does 'not working' mean - error, wrong results, nothing happens?

If you want to provide db ...

[bradp1979]

Still not working. Here's the form in both print preview and design view, and the query. Also, I included the form the query is drawing from. Name is "EntityName", and Contact is "ClientName". I don't understand why it's not working.

Special Events Report Sheet:


Special Events Report Sheet design view:


qrySERS:


Special Event Form:

[ssanfu]

You have the field alias set to the same name of the field.
Maybe Access is confused. Try changing the alias to something else:

sEntityName: NZ(EntityName, ClientName)

Add another column just for a check:

EName:IIF(EntityName is null, ClientName, EntityName)

[June7]

However, the expression in textbox should be working, assuming the referenced fields are in the query.

[bradp1979]

Ok. Works now. I put "=IIF(IsNull([EntityName]),[ClientName],[EntityName])" in the textbox, and it's all good.

Thank you!