Re: Using COUNT and ORDER BY in a SQL Statement

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

From: Evertjan. (exjxw.hannivoort_at_interxnl.net)
Date: 03/15/04 

Date: 15 Mar 2004 21:55:37 GMT

Wole wrote on 15 mrt 2004 in microsoft.public.inetserver.asp.db:

> SELECT COUNT(*) AS RSCOUNTER FROM tblStaffInfo ORDER BY username
>
> but I get the error message:
>
> Error Type:
> Microsoft JET Database Engine (0x80040E21)
> You tried to execute a query that does not include the specified
> expression 'username' as part of an aggregate function.

Seems logical you cannot order a one number result output. 

-- 
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

Relevant Pages

  • Error 3197
    ... "The Microsoft Jet database engine stopped the process because you and ... 3197)" is the error message I got last night when I was typing information ... Every time I try to type in the form or the table I get that error message. ...
    (microsoft.public.access.gettingstarted)
  • Dreaded Jet DB error 80004005 help needed. What causes this???
    ... I'm trying to understand what causes this error message: ... Microsoft JET Database Engine error '80004005' ... The Microsoft Jet database engine cannot open the file ...
    (microsoft.public.inetserver.asp.db)
  • Error 3197
    ... Receiving the above error message on start up reporting ... that the "Microsoft Jet Database engine stopped the ...
    (microsoft.public.windowsxp.general)
  • Error 3197
    ... >Receiving the above error message on start up reporting ... >that the "Microsoft Jet Database engine stopped the ...
    (microsoft.public.windowsxp.general)
  • JET DB Engine 80004005 error
    ... Here is the error message I get ... Microsoft JET Database Engine ... Ben (email address on request) ...
    (microsoft.public.inetserver.asp.general)