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? .