Gilbert If I get your question right, you need to pull down fields LibA and LibB from Table_A and Table_B respectively in the QBE grid. Then under LibA and the row UPDATE TO write [Table_B].[LibB]. This will update LibA with LibB values. Do not forget the square brackets
HTH Liveson ----- Original Message ----- From: Clauss Gilbert To: [email protected] Sent: Tuesday, 21 April, 2009 18:22 PM Subject: [ms_access] Correlated query With the QBE interface, with two tables Table_A and Table_B, how can I produce that code ? (it's easier directly in SQL :-) UPDATE Table_A INNER JOIN Table_B ON Table_A.IdA = Table_B.IdB SET Table_A.LibA = Table_B.LibB Gilbert Clauss Tél : 01 41 17 56 20 www.sauvonslastatistiquepublique.org <http://www.sauvonslastatistiquepublique.org/> [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
