Hi there,
It's been a long time since I used Access, so I am having to familiarize myself with it. So apologies if this is an obvious question.
I am trying to combine a number of fields into one field to create the body, (in HTML), of my product descriptions.
If the field is populated I want it to put:
'SOME TEXT' - 'THE CONTENTS OF THE FIELD'<br />
If the field is blank, I don't want anything for this part. At the moment, when the field is blank, I get:
'SOME TEXT' - <br />
Here is what I have put:
Body (HTML)1: "<p>" & [ShortDescription] & "<br />" & [LongDescription] & "</p>" & ("Age restriction - "+[comp age restriction]+"<br />")
The age restriction bit is what I am stuck on, as it returns the following for all the blank fields:
Age restriction - <br />
I want to do this for all the COMP fields but am just asking about the COMP AGE RESTRICTION for simplicity sake.
I have attached a copy with some sample data.
It's been a long time since I used Access, so I am having to familiarize myself with it. So apologies if this is an obvious question.
I am trying to combine a number of fields into one field to create the body, (in HTML), of my product descriptions.
If the field is populated I want it to put:
'SOME TEXT' - 'THE CONTENTS OF THE FIELD'<br />
If the field is blank, I don't want anything for this part. At the moment, when the field is blank, I get:
'SOME TEXT' - <br />
Here is what I have put:
Body (HTML)1: "<p>" & [ShortDescription] & "<br />" & [LongDescription] & "</p>" & ("Age restriction - "+[comp age restriction]+"<br />")
The age restriction bit is what I am stuck on, as it returns the following for all the blank fields:
Age restriction - <br />
I want to do this for all the COMP fields but am just asking about the COMP AGE RESTRICTION for simplicity sake.
I have attached a copy with some sample data.