How to create a birthday list.

[Mark Rawson]

I have setup a table that allows the users to imput a
husbands name and birthday, they can then enter the same
information for the wife, and up to four children. All
this information is kept in one record for that family.
Each person gets their owe first and last name field, and
also get their owe birthday field. I need to create a
report that lists each persons first and last name and
gives their birthday. I want to sort all birthdays in
order for all records. If I was going to store each name
and birthday in the same field name, this would be easy,
but that is not the way I have each record setup.

Any ideas?

thanks
mark

 

[John Vinson]

I have setup a table that allows the users to imput a
husbands name and birthday, they can then enter the same
information for the wife, and up to four children. All
this information is kept in one record for that family.
Each person gets their owe first and last name field, and
also get their owe birthday field. I need to create a
report that lists each persons first and last name and
gives their birthday. I want to sort all birthdays in
order for all records. If I was going to store each name
and birthday in the same field name, this would be easy,
but that is not the way I have each record setup.

Yep. You're having trouble because your database is incorrectly
normalized.

"Fields are expensive, records are cheap". If you have six people in a
family, you should have six RECORDS in a people table, one record per
person; this table would be related one-to-many to a Family table.

You can use a UNION query to untangle your current non-normalized
table: see the online help for UNION or post back with the fieldnames
of your current table if you need help.

 

[Mark Rawson]

Hello John,

Thanks for the great help. I was at BN digging thru tons
of access books and could not find any good leads. I was
hoping that I could stay away from separate records for
each person, but that might make the most sense.

mark

 

[John Vinson]

Hello John,

Thanks for the great help. I was at BN digging thru tons
of access books and could not find any good leads. I was
hoping that I could stay away from separate records for
each person, but that might make the most sense.

A professor that my wife worked with has thirteen children... <g>