Prev: Use of Parntheses in Expressions
Next: How to set the parameter query for this case?
From: John W. Vinson on 7 Jun 2010 01:45
On Mon, 7 Jun 2010 23:13:18 -0400, "JR" <iloveVBA(a)gmail.com> wrote:

>in the query view or sql view?

You can use either, but in the query grid (which is NOT the query, just a tool
to help build SQL) you'll need to put the subquery - as a SQL string in
parentheses - in the Criteria box. You'll need to adapt the fieldnames and
tablenames to match your actual tables, which I cannot see.
--

John W. Vinson [MVP]
From: JR on 8 Jun 2010 18:46
Absolute brilliance!

Thanks so much, John.


"John W. Vinson" <jvinson(a)STOP_SPAM.WysardOfInfo.com> wrote in message
news:to1p06pdr15b942lo90r488c20q0hr4ov6(a)4ax.com...
> On Mon, 7 Jun 2010 23:13:18 -0400, "JR" <iloveVBA(a)gmail.com> wrote:
>
>>in the query view or sql view?
>
> You can use either, but in the query grid (which is NOT the query, just a
> tool
> to help build SQL) you'll need to put the subquery - as a SQL string in
> parentheses - in the Criteria box. You'll need to adapt the fieldnames and
> tablenames to match your actual tables, which I cannot see.
> --
>
> John W. Vinson [MVP]


First  |  Prev  | 
Pages: 1 2
Prev: Use of Parntheses in Expressions
Next: How to set the parameter query for this case?