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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Update tabke from other table with criteria
Somedy told me the solution: UPDATE DataTable INNER JOIN DataSumTable ON DataTable.[Date] = DataSumTable.[Date] AND DataTable.A_Name = DataSumTable.A_Name SET DataTable.SumHours = DataSumTable.SumHours- tomash01
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
-
Update tabke from other table with criteria
Hi! I ve got two tables in Access 2007. I want to update a field of DataTable from another table, DataSumTable when two of their fields equals. ( the fields : Name and Period) I tried this sql code: UPDATE DataTable SET DataTable.SumHours = ( SELECT DataSumTable.SumHours FROM...- tomash01
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
