Access - Drag Same Field Twice in a Query

tahirih
tahirih used Ask the Experts™
on
Please offer how in table "A" I have the field [Name_ID]. In a query, I would like to drag this field twice...once when it is the first field in the query (not the original position), and then re-include in the 10th position (original position).

In the first position, I would like this field to be renamed newly as [ID].

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
First create the new column in the table

Then:

UPDATE [TableName]
SET [ID] = [Name_ID]

Author

Commented:
Thanjs

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial