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]