qa.thundersoftware.com

[jkusner]

How can I generate a list of first and last names, addresses, and birth dates in order of birth date?. I entered everyone as month/day/0001 because I did not have all of the years, and also because I don't necessarily need to know the age...only the month and day of birth. Each month, I send out birthday cards, so I need a list that will display all of the birth dates in order.
-- gail

[jkusner]

you can generate a list of individuals whose birth date falls in a certain month, try running the following sql in the query window. just change the month number to whichever month you are interested in. then, if you want you could export the data to excel or another format to work with or just print the list out.

SELECT "birth_dt"=convert(char(10),a.birth_dt,101),
a.name_last, a.name_first,
"lastfirstname"=rtrim(a.name_last)+', '+rtrim(a.name_first),
"firstlastname"=rtrim(a.name_first)+' '+rtrim(a.name_last),
b.address, b.city, b.state, b.postal_code
FROM individual a, family b
WHERE a.family_id=b.family_id
and month(a.birth_dt)=12
and a.active_ind='Y'
ORDER BY day(a.birth_dt)

in the query above it reads, hey, i want to see the birth date in mm/dd/yyyy format, the last name, the first name, the the combined names in last name first name format, then the combined name in first name last name order (you can remove if you want), also show the address, city, state and zip. the data is coming from two tables, the individual and family tables....those two tables are linked using the family_id column. i only want to see where the month portion of the birth date is 12 and where the individual is flagged as active. once you assemble all the data then sequence it by the day of the month of the birth date.

we'll also consider adding a checkbox or something on the labels and letters widnow when searching for individuals to only search by the birth month.

[jkusner]

option in the labels/letters module to filter by birth month. coming 7/2006