Running function on field and saving results to new table

[meadt]

Hi guys,

I have been struggling with this one all morning and can't seem to get anywhere. I need to run a function on a whole field of data and return the results to a new field in a blank table. I have been trying to use SQL functions without any luck.

I'm pretty new to VBA so nice and simple explanations! lol!

Thanks in advance for any help!

 

[ajetrumpet]

the general syntax would be like that of a make-table query. so:

SELECT

function([fieldname]) as NEWFIELDNAME

INTO NEWTABLENAME

FROM yourTable

 

[meadt]

Hi Again,

Still having a little trouble with this. I'm trying to run the function on the field using

DoCmd.RunSQL "UPDATE [Command Data Table] SET [Command Word]= ********;"

What would go in place of the stars to address the function?
The code I'm trying to run is titled:

test - Module2
Public Sub DatExtract()

Cheers,