SQL Query problem...

[Mike Hill]

Here is a query I am trying to execute.

SELECT ConsultantPIN, CFirstName, CLastName, Count(DateSubmitted) AS [Total]
FROM consultant_DS WHERE DateSubmitted >=#02/01/2004# and DateSubmitted
<=#2/29/2004# Group By ConsultantPIN, CFirstName, CLastName Order By Total
DESC;

My problem is that I am trying to use Total from ...Count(DateSubmitted) AS
[Total].... in the Order By Statement.
It will not let me. I can use ConsultantPIN, CFirstName or CLastName.

Any suggestions.

Thanks,
Mikeal

[Aaron Bertrand [MVP]]

ORDER BY Count(DateSubmitted) DESC

?

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]


"Mike Hill" <mhill7272(at)hotmail.com> wrote in message
news:OnDTz3DGEHA.3984@TK2MSFTNGP10.phx.gbl...

> Here is a query I am trying to execute.
>
> SELECT ConsultantPIN, CFirstName, CLastName, Count(DateSubmitted) AS
> [Total]
> FROM consultant_DS WHERE DateSubmitted >=#02/01/2004# and DateSubmitted
> <=#2/29/2004# Group By ConsultantPIN, CFirstName, CLastName Order By Total
> DESC;
>
> My problem is that I am trying to use Total from ...Count(DateSubmitted)
> AS
> [Total].... in the Order By Statement.
> It will not let me. I can use ConsultantPIN, CFirstName or CLastName.
>
> Any suggestions.
>
> Thanks,
> Mikeal
>
>

[Mike Hill]

Thanks!
That did it.

"Aaron Bertrand [MVP]" <aaron@TRASHaspfaq.com> wrote in message
news:O$Bu56DGEHA.3724@TK2MSFTNGP11.phx.gbl...

> ORDER BY Count(DateSubmitted) DESC
>
> ?
>
> --
> Aaron Bertrand
> SQL Server MVP
> [url]http://www.aspfaq.com/[/url]
>
>
> "Mike Hill" <mhill7272(at)hotmail.com> wrote in message
> news:OnDTz3DGEHA.3984@TK2MSFTNGP10.phx.gbl...

> > Here is a query I am trying to execute.
> >
> > SELECT ConsultantPIN, CFirstName, CLastName, Count(DateSubmitted) AS
> > [Total]
> > FROM consultant_DS WHERE DateSubmitted >=#02/01/2004# and DateSubmitted
> > <=#2/29/2004# Group By ConsultantPIN, CFirstName, CLastName Order By

Total

> > DESC;
> >
> > My problem is that I am trying to use Total from ...Count(DateSubmitted)
> > AS
> > [Total].... in the Order By Statement.
> > It will not let me. I can use ConsultantPIN, CFirstName or CLastName.
> >
> > Any suggestions.
> >
> > Thanks,
> > Mikeal
> >
> >

>
>