• Post Reply Bookmark Topic Watch Topic
  • New Topic

What is the standard SQL to select "age groups"?

 
Jacky Luk
Ranch Hand
Posts: 634
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
1) Under 18
2) 19-24
3) 25-34
etc

How do I use a SQL string to select the number of people inside each age group?
Better off to have a resultset to collect the whole bunch
Could you give an example?

Doesn't work here

thanks
Jack
 
Jacky Luk
Ranch Hand
Posts: 634
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Jacky Luk wrote:1) Under 18
2) 19-24
3) 25-34
etc

How do I use a SQL string to select the number of people inside each age group?
Better off to have a resultset to collect the whole bunch
Could you give an example?

Doesn't work here

thanks
Jack


Solved. Thanks guys
http://bytes.com/topic/access/answers/944596-make-age-range-query-select-men-between-these-ages
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!