group by clause

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top