Re: SQL Division

Tech-Archive recommends: Fix windows errors by optimizing your registry

Why would Jamie Collins want to impersonate Aaron K.e.m.p.f?

http://groups.google.com/group/microsoft.public.access/browse_thread/thread/a147071cee7fbd4f/c4ff024bd7652b5b?&hl=en#c4ff024bd7652b5b

--
--Roger Carlson
MS Access MVP
www.rogersaccesslibrary.com

<AaronKempff@xxxxxxxxxxxxxx> wrote in message
news:1179996365.944060.225650@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On May 23, 2:51 pm, "Roger Carlson" <RogerCarl...@xxxxxxxxxxxxxxx>
wrote:
In Access, the only way you can have a Subquery in the FROM clause is to
surround the subquery with brackets ([]), NOT parenthases. The problem,
however, is that you CANNOT, then have any brackets in your subquery.

Oh yeah?

select *
from (
select OrderID, max(UnitPrice)
from [Order Details]
group by OrderID
) as t

I suppose this is an IMPOSSIBLE query that can just never be made to
work in Access? LOL

Want answers to your Access answer?



.

Relevant Pages

  • Re: Allen Brownes Search2000
    ... Yes, the subquery needs to be in parentheses, so you need to add a closing bracket to get: ... Allen Browne - Microsoft MVP. ... ending parenthesis. ... Make sure the brackets match, ...
    (microsoft.public.access.formscoding)
  • Re: Count Unique Values in a Totals Query
    ... The catch is Access will not allow any square brackets in a subquery. ... John Spencer ... Query Two uses the SAVED query ...
    (microsoft.public.access.queries)
  • Re: SQL Division
    ... however, is that you CANNOT, then have any brackets in your subquery. ... brackets and parentheses within the subquery ... the SQL text remains identical. ...
    (microsoft.public.access.queries)
  • Re: query wont run in access 97
    ... It returns a syntax error FROM Clause. ... A Jet subquery used in a FROM clause will always ... it is wrapped in brackets with an ending period ... or the Jet query parser will choke on them. ...
    (microsoft.public.access.queries)
  • Re: Count Unique Values in a Totals Query
    ... It will make the subquery surrounded by brackets and followed by a period. ... Query Two uses the SAVED query ... as UniqueData ...
    (microsoft.public.access.queries)