Re: [ms_access] Correlated query
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: ms_access@yahoogroups.com 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]
Re: [ms_access] Correlated query
Open your query in SQL view. Paste that code. Then change it to design view and it will show you how it looks. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us --- On Tue, 4/21/09, Clauss Gilbert gilbert.cla...@insee.fr wrote: From: Clauss Gilbert gilbert.cla...@insee.fr Subject: [ms_access] Correlated query To: ms_access@yahoogroups.com Date: Tuesday, April 21, 2009, 9:22 AM 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.sauvonslastatis tiquepublique. org http://www.sauvonsl astatistiquepubl ique.org/ [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]