Add apostrophe's to mixed data

[Jake94]

Hi, I am combining fields one that has apostrophe's and the other does not. exp "if this field is null use data from this field (which does not have an apostrophe) otherwise use current field (which has apostrophe)

"red"
blue
orange
"yellow"

How can I change that in the query without changing the previous query to

"red"
"blue"
"orange"
"yellow"

Thanks!

 

[plog]

Your entire post was filled with ambiguity. You mentioned 2 fields of data and posted 2 sets of data, but I'm unsure of if that data was before and after, or each fields values.

Then you posted this:

How can I change that in the query without changing the previous query to

What's the previous query? We have no frame of reference for anything you've mentioned, you need to be more clear when referencing fields and queries and other objects. Explicitly name them and identify them when referencing them.

I think it would be best if you posted two more sets of data: what is currently in relevant tables/queries and then what you ultimately want. Include field and table names. Use this format for posting:

TableNameHere
Field1Name, Field2Name, Field3Name
David, 15, 2/16/2008
Sally, 44, 7/4/2005
Larry, 4/8/2010

 

[WayneRyan]

Jake,

Assuming your column name is color ...

Select Chr(34) & Replace(Color, Chr(34), '') & Chr(34)
From   YourTable

Wayne