Queries - Removing <Div Tags>

[9944pdx]

Hi there,

I have a query field that looks like this:

Table: [Notes] + " . " + [Location]

Wanted Output: Removed Wheel. Portland



Issue: Div Tag has been place around "Removed Wheel"

Actual Output: <div>Remove Wheel</div>. Portland


Thanks again for your support.

[NTC]

well I'm pretty sure that 'Table' is a reserved word. So that's the first point.

not sure I understand your post...but assuming you have a query, in query design - and are making a calculated field....let's change the name and syntax to this:

NewTable: [Notes] & " . " & [Location]

this presumes that [Notes] [Location] are field names from a table in the query design...and we're now using the non reserved NewTable name.....

Hope this helps.

[9944pdx]

You are correct I have a query, in query design with a calculated field.

Your post helped and it works...but:

When there is data in the [Notes] field and [Location] field I still receive the div tag.
ex: PDX + <div>Wheel fell off car</div> How do I remove div tag?

I don't see the div tag if the [Notes] field is empty.
ex: PDX +

Question:

Do you think I should add an IF statement, so that if nothing appears in the [Notes] field then don't do anything?

[NTC]

I don't know what you mean by 'div tag' and where is that + symbol coming from?

[9944pdx]

Something in the design query is addding div tags (shown below in quotes)

ex: PDX +

<div>

Wheel fell off car

</div>

My question: what do I need to remove the div tags from being brought in to the output?

Thanks for your help.

[9944pdx]

Found the problem.

Formatting issues:

Right click Specified field>view property sheet>text format>change to Rich Text.