" & " Text Box in a Report

F

FrankieinFlorida

=Trim([Owner1LastName] & " & " & [Owner2LastName])

If Owner2LastName fields is null, how do I make the & not show up on the
report?
Please help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report text box pull one or many landowners/fields. 3
Access 2002 change report header text 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Program buttons to create a word document 0
How to have two tables on same line? 1
Mis-performing MP4 files in Mac PPT 1
How to automate update on weekly reports spreadsheet 0
Link a text box based on drop down box with four options MS Word 365 0

Top