Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • 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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic