Access: Combine 2 Fields in 1 with SQL Code -

i'm trying combine 2 field in 1 in table. shall excecuted clicking on button. thought work this:

private sub button_click()  dim strsql string  strsql = "select table.field1 & "" & table.field2 table.field12"  currentdb.execute strsql  end sub 

clearly isn't working @ all.

any ideas how solve problem?

if wish update, must use action query, like:

strsql = "update table set field12 = field1 & field2" 

if wish select, must valid select query:

strsql = "select *, field1 & field2 field12 table" 

but cannot "execute". however, can open recordset.