<p> in a Query

  • Thread starter Thread starter Jack
  • Start date Start date
You can add a constant column to a query. You will probably want to
name this column as well. For a constant text column, you might have:

ColumnName: "Your text goes here."

just put this into the Field row of the design grid in a new column.
That should do it.

Is there anyway I can enter the words bellow in a query
Field?
This line has to be added to every line. That's the way I
have to submit my filtered table.
Thanks

<p><img border="0" src="http://abcdefg.com/images/
Click to expand...

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
To expand on Tom's answer, in case you are having problems with the quotation marks

Field: FixedText: "<p><img border=""0"" src=""http://abcdefg.com/images/"

Note that everywhere you had a single quotation mark, I placed two quotation
marks. In addition, I added one at the start of the string and one at the end.
 
This works fantastic.
Thanks

Can you shortly explain me or give me a link to understand
why you need two quotation marks?
-----Original Message-----
To expand on Tom's answer, in case you are having
Click to expand...
problems with the quotation marks
Field: FixedText: "<p><img border=""0"" src=""http://abcdefg.com/images/"

Note that everywhere you had a single quotation mark, I placed two quotation
marks. In addition, I added one at the start of the string and one at the end.


Tom said:
You can add a constant column to a query. You will probably want to
name this column as well. For a constant text column, you might have:

ColumnName: "Your text goes here."

just put this into the Field row of the design grid in a new column.
That should do it.
Click to expand...
Click to expand...
 
Because Access uses the quotation mark as the beginning and ending of a string -
BUT if you put two quotes together inside another set of quotes Access will
convert the two inner quotation marks to one quotation mark and strip off the
external quotation marks.

The online help should explain this more thoroughly, if you can get the online
help to let you find the explanation. Try entering "Quotation Marks in Strings"
or "Quotation Marks in expressions" in the help.
This works fantastic.
Thanks

Can you shortly explain me or give me a link to understand
why you need two quotation marks?
-----Original Message-----
To expand on Tom's answer, in case you are having
Click to expand...
problems with the quotation marks
Field: FixedText: "<p><img border=""0"" src=""http://abcdefg.com/images/"

Note that everywhere you had a single quotation mark, I placed two quotation
marks. In addition, I added one at the start of the string and one at the end.
Click to expand...
Click to expand...
 
Back
Top