Help! Can I actually do this in a report? (1 Viewer)

ALewis06

Registered User.
Local time
Today, 16:53
Joined
Jun 21, 2012
Messages
124
I have a table in Access 2010 containing the results of a survey. One of the fields in table is the actual quotes from customers who gave direct feedback. I have created a simple report containing all of the quotes. My manager would liek them included in a summary Word doc but wants quotation marks around every quote. It's too many to manually after the report is exported to Word. Is there a way to include quotation marks around the field in the report design view?
 

vbaInet

AWF VIP
Local time
Today, 21:53
Joined
Jan 22, 2010
Messages
26,374
You can do it in a query and use the query as the source of your report.

Create a field in the query like this:
Code:
Alias: """" & [[COLOR="Blue"]FeedbackField[/COLOR]] & """"
 

ALewis06

Registered User.
Local time
Today, 16:53
Joined
Jun 21, 2012
Messages
124
Perfect, thanks!
 

Users who are viewing this thread

Top Bottom