How can I copy data from one field into another?

[Mir.]

In a Query, I need to copy text data in one Field into another field in the
same query. Any way of doing this? In otherwords, 2 fields need the same
data.

 

[KARL DEWEY]

Use an update query.

 

[John W. Vinson]

In a Query, I need to copy text data in one Field into another field in the
same query. Any way of doing this? In otherwords, 2 fields need the same
data.

Just include the field twice in the query grid, giving it an alias name for
the second instance. That is, if your table contains a field named FOO and you
want to see that field both under the name FOO and under the name BAR, type or
select

Foo

in one vacant Field cell, and type

Bar: [Foo]

in another.