DJK Robinson
djkr at msn.com
Sun Jun 23 10:01:33 CDT 2013
So would this qualify, for example? INSERT INTO archivetitles (title_id, title, type, pub_id) SELECT title_id, title, type, pub_id FROM titles WHERE (pub_id = '0766') John ---------------------------------------- > Date: Sun, 23 Jun 2013 08:52:46 -0500 > From: fuller.artful at gmail.com > To: accessd at databaseadvisors.com > Subject: Re: [AccessD] QyeryDef.Type dbQCompound > > Michael, > > I would definitely accept that definition of a compound query. > > Arhur > > > On Sun, Jun 23, 2013 at 8:47 AM, Michael <michaeljrobertson at gmail.com>wrote: > >> Gustav. >> >> Have a look here >> >> http://english.tebyan.net/newindex.aspx?pid=31159&BookID=23853&PageIndex=227 >> &Language=3 >> >> From this source it seems that a compound query contains both a select >> query >> and an action query. >> >> Michael >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock >> Sent: Sunday, 23 June 2013 5:52 PM >> To: accessd at databaseadvisors.com >> Subject: [AccessD] QyeryDef.Type dbQCompound >> >> Hi all >> >> Could anyone please tell me what a compound query in Access is? >> >> Of course, I've binged/googled and searched the on-line "help" but didn't >> find a single clue. >> >> /gustav >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> > > > > -- > Arthur > Cell: 647.710.1314 > > Prediction is difficult, especially of the future. > -- Niels Bohr > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com