DeathCase

[endri81]

Hi.
In one table I have
1.column of personbirthday(yy-mm-dd)
2.column of personage(year)
3.column deathaccident
4.column deathnatural
5.death suicide

How to create a query for reporting death by age groups like 30-40 40-50 etc and death kind?

 

[MarkK]

Cause of death should be a single column. Accident, Natural and Suicide are data, not structure. Commonly you'd create another table ...

tDeathType
DeathTypeID (PrimaryKey)
DeathType

And your existing table would change to ...

tPerson
PersonID (PrimaryKey)
DeathTypeID (ForeignKey)
Birth
Age

Then writing queries agains DeathType is very easy because you don't have to look in three different fields.
Cheers,