 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / February 2008How can I copy data from one field into another?
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. Use an update query.  SignatureKARL DEWEY Build a little - Test a little > 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. 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. SignatureJohn W. Vinson [MVP] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.