Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Update two FIELD names in one table with TEXT from another table
I should have mentioned that the example was a segment of the queries. I'm trying to automate this report as much as possible for the end user. The database has a number of queries, and table [00_T_Update Years] will be updated prior to running them. Currently, it only requires that the user...- ERMQ
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Update two FIELD names in one table with TEXT from another table
Hello, I have basic Access and VBA knowledge. I need to update two FIELD names in one table with TEXT from another table. For example: The field name [Class Rate Table]![PrevYr Class Weighted Rate Change] needs to be updated with the text present in [00_T_Update Years]![Map Field Name] where...- ERMQ
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
