CutAndPaste
Registered User.
- Local time
- Today, 22:41
- Joined
- Jul 16, 2001
- Messages
- 60
I have a query that calculates Clients Ages in whole years. I want to be able to group my query output into a report grouped by age bands, say <16,16-20,21-30, >31 etc. and then be able to use the results of this in other groupings e.g. Gender by Age Band, or Favourite Fruit etc.
How can I create these age bands in a query? what's the SQL?
How can I create these age bands in a query? what's the SQL?