Web Development

Ask something
Question Locked

Help with Access Queries?

0 helpful
3 replies

by pdx9944

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Workign with Access 2007 queries -
Currently working in query>design view the field works but in the output it is bringing in div tags.
Test Notes: IIf([Notes]="",[Location],[Location] & " " & [Notes])

example of output field: Chicago

Bus Driving over the line.

Correct output should be: Chicago Bus Driving over the line.
Any ideas? .

3 replies

by Former member

Try this:

Right click on your specified field, view property sheet then change text format to Rich Text.

by pdx9944

Hi Andrew, I have changed text format before, i have to run this query 20 times per day and I don't want to have to change the format everytime I run it. I heard there might be another way perhaps:
ex:Replace((Replace([Notes],"

","")),"

","")
Though, I am not sure how to add it to:
left([right([Notes],instr([Notes],"

")-1)],instr([right([Notes],instr([Notes],"

")-1)],"

")-1)
I might off-base and unrealistic.

pdx

This discussion is closed to new replies.