[AccessD] QyeryDef.Type dbQCompound

Hi Asger

Well, I've seen this explanation somewhere, but I guess most of us have had a, say, select query using a subquery, and it was listed as any other query in Access.

The Type property probably controls the icon associated with the query in the object browser, and I think I've seen them all just not this "compound" query.

/gustav

>>> ab-mi at post3.tele.dk 23-06-13 13:45 >>>
Maybe a query containing a sub-query? Not at my computer now so can't check.
/ Asger

----- Original meddelelse -----

> Fra: Stuart McLachlan <stuart at lexacorp.com.pg>
> Til: Access Developers discussion and problem solving
> <accessd at databaseadvisors.com>
> Dato: Søn, 23. jun 2013 12:32
> Emne: Re: [AccessD] QyeryDef.Type dbQCompound
> 
> Good guess - But fail :-(
> A Union query is Type 128 = dbqSetOperation
> 
> Stilll trying to generate a query that returns dbqCompound.
> 
> --
> Stuart
> 
> 
> On 23 Jun 2013 at 20:26, Stuart McLachlan wrote:
> 
> > A "Union" query?
> >
> > --
> > Stuart
> >
> > On 23 Jun 2013 at 9:52, Gustav Brock wrote:
> >
> > > 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