How can I copy data from one field into another?

  • Thread starter Thread starter Mir.
  • Start date Start date
M

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.
 
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.
Click to expand...

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.
 
Back
Top