copy data and place in another field

[tubar]

how do you create a query that will select a certain field and all its records and put those values in another field in the same query. THEN (and this might be another query) i want to put todays date in the date field of every record in this query.

 

[Brianwarnock]

I'm sure that I don't understand what you are doing but to select records that have a field whose value meets a certain criteria then select the fields in the record and in the criteria row for the given field enter the criteria,
To create a new field containing an existing field's data, why would you do that? then create a new column in the query
Newfield: oldfieldname
ditto for Date
Datefield: Date()

Brian