Unbound Field

[Samantha]

I have an unbound field that I have used the expression builder to populate and it needs minor tweaking. I just can't remember how
The code currently reads as follows:

=[Company]+ " " +Nz([EngineerCompany])

Instead of the blank spacing between them I would like it to read ([Company] by [Engineer]) however not every company uses a Engineer so in those instances it should only read [Company]

Any help is greatly appreciated!
Samantha

 

[bob fitz]

Perhaps:

=Trim([Company] & " " & Nz([EngineerCompany],""))

 

[Samantha]

Thanks for your response Bob. As I understand trim is to remove leading or trailing spaces? I plugged it and didn't get the results I was hoping for. Any other ideas?

 

[Samantha]

Ahh, I figured it out. Thanks Bob you got my wheels turning!

=[Company]+Nz(" By "+[EngineerArchitectCompany])