Re: group by clause

Hi,



SELECT COUNT(*)
FROM yourQuery


returns the number of records in your query.



SELECT *
FROM myTable
WHERE ( "," & param & "," ) LIKE ("*," & fieldName & ",*")


would return the records that are one of the numerical values represented in
param, supplied like:

3,4,7


(to keep records whre fieldName is either 3, 4, or 7). Note there is no
space after the , to be supplied in param.




Hoping it may help,
Vanderghast, Access MVP



"rv" <rv@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C59D6268-83C7-464F-BA74-1AD2CCCE5D87@xxxxxxxxxxxxxxxx
>I want to count the number of groups returned by a query. Conversely can
>some
> one help me in creating a query which will take a number like 3 or 4 or 5
> as
> input and return those many groups of record.


.

Relevant Pages

  • RE: parameter in sql query
    ... Just set connection string to run it. ... > If the substition is before...the error seems to imply that the query is ... > being transferred to the sql server without the parameter being replaced ... > creating a datacomponent with a sql param, ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: stored proc RETURN_VALUE.... there it is, I want to use it !!!
    ... > Then you can read the value of @total after closing the query. ... > 2 Set up your input param values. ... the result of this sql code returns an integer that is ... >> take the guts of the stored proc with hard coded guestid and meeting ...
    (borland.public.delphi.database.ado)
  • Re: stored proc RETURN_VALUE.... there it is, I want to use it !!!
    ... Then you can read the value of @total after closing the query. ... Set up your input param values. ... > take the guts of the stored proc with hard coded guestid and meeting code ...
    (borland.public.delphi.database.ado)
  • Re: Query optimization
    ... But my manager is asking me to use the existing parameter @param and not to ... I have no clue how to change this query to suit this revised requirment. ... From tblT T join tblD D on T.DEVID = D.DEVID ... Select TOP 2 D.state as state, sumas amount ...
    (microsoft.public.sqlserver.programming)
  • Re: parameter in sql query
    ... Could you try expanding the autogenerated code and posting ... > Does the parameter substitution occur after or before the query is sent to ... > being transferred to the sql server without the parameter being replaced ... '@Start' is the name of the param and the error says there ...
    (microsoft.public.dotnet.framework.compactframework)