how to put dato from one field to another

[darwin]

hi

I have a Query

The Query has a field name "Test: ....." with a query statement

What I want is a statement which put the data from "Test" to the field Ugenr1



how do I do this

[ItsMe]

Your question is straightforward. However, there are a few ways to go about this and. perhaps, you only want to UPDATE one record. An action query could UPDATE every record. From a form, you could simply use some VBA.

Me.NewFieldName.Value = Me![Test]