I have a problem where I need to population of no more than 1000 customers. I can have less but not more. Within this 1000 I can up to 100 kids under 12, up to 100 kids 12-18, 100 seniors over 65, etc.
Since my population may only have 30 kids up to age 12, I can fill the remaining 70 with adults between 19 and 64.
I've got different data sets for each population and I've got case statements for each age group.
My problem comes with trying to take the 1000 minus the kids age 12, minus the kids up to 18 and then seniors over 65..
Any help would be appreciated.
dtmba59
0
Newbie Poster
happygeek
2,411
Most Valuable Poster
Team Colleague
Featured Poster
Hi guy, welcome to Daniweb. This isn't the right forum for requesting help, it is a place to say 'hello' and get waved at back.
In order to point you at a more appropriate forum for the question you need to tell us what platform and what database app you are using.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.