Look up the INSERT INTO query type and syntax in help. You will want to do an INSERT INTO table2 SELECT fields from table1
HTH, Toby ----- Original Message ----- From: "angusnisbet" <[EMAIL PROTECTED]> To: <AccessDevelopers@yahoogroups.com> Sent: Saturday, October 29, 2005 2:33 PM Subject: [AccessDevelopers] Update from aggregate query > I would like to use a certain field from an aggregate select query > (which I have already constructed) populate a field in a table. > > I have experimented with Update queries, DLookup(), should I use some > loop system (though I have never done that in Access)? > > I am not very advanced at this so please explain slowly, example > syntax would be helpful. > > Many thanks in advance. > > > > > > > > Please zip all files prior to uploading to Files section. > Yahoo! Groups Links > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
