is it possible?: edit values in a make table query

[machumpion]

Let's say I wanted to make a table from an existing table. In the new table, I'd like all the records from the existing table, except I'd like to supplement them with one asterisk in the beginning of the value and one asterisk at the end. Is this possible to do within a Make Table query? Thanks!

 

[Minty]

Yes - what have you tried ?

 

[machumpion]

Yes - what have you tried ?

I've tried putting "*" & [fieldname] & "*" in the "field" section of the query designer

 

[Minty]

That should work;

MyNewField: "*" & OldField & "*"

It does here.