This is my first post, I have tried the search function but I couldn't find anything that matched my question.
Within my Art Gallery database I have created separate fields for Y, X. Z dimensions of the artworks. I did it because I need the values to bo converted automatically in inch and cm.
Now I'd like to have a field that contains the three values separated by the symbol x, for example: 123 x 34 x 70 - this can be done withj merge field, but I also want to hide the last part if the Z value is empty 123 x 34 (deleting also the symbol x before 70).
I am sure is something really basic to ask, but I have no clue of how to do it!
Many thanks for your help,