Re: Very complex query

Yes, but the IN(SELECT statements will be different depending on the
selections in the filter. The object of the IN(SELECT statements is to filter
the drawings list for those drawings that are open in a specific phase of the
drawing cycle.

Rob Oldfield wrote:
>Will it always be the case that the select dmsid in(...) and dmsid not
>in(...) will be the same for each of the OR sections?
>
>> Here it is:
>>
>[quoted text clipped - 45 lines]
>>
>> BIll


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200510/1
.

Relevant Pages

  • Re: Filter 2 separate columns in Excel
    ... "Gordon" wrote: ... "Martin" wrote: ... drawings with project number 1234. ... No you can filter on two columns - it seems that you need to select ALL the ...
    (microsoft.public.excel.newusers)
  • Re: PDM reporting feature?!?!?!
    ... a report and export it into an excel spreadsheet. ... a report for a major assembly with numerous parts (and their drawings) ... However, PDM seems ... that would somehow filter out some drawings? ...
    (comp.cad.solidworks)
  • Re: Where is the fuel filter located on a Honda Civic 1991 ??
    ... You can also look at the drawings at www.slhonda.com (parts ... attached to the firewall (closer to the passenger side) ... located on a 1991 Honda Civic hatchback? ...
    (rec.autos.makers.honda)
  • Re: Very complex query
    ... run multiple times: twice in the example you give, ... AND DMSID NOT IN( ... SELECT dmsid FROM tblPhase INNER JOIN (INNER JOIN tblDates ON ... > the drawings list for those drawings that are open in a specific phase of ...
    (microsoft.public.access.queries)