MrRadio915
New Member
- Joined
- Dec 20, 2005
- Messages
- 24
I do a Kids Radio program every week in which I do a birthday club.
Presently I have the data in an excel workbook and have individual columns for M, D and Yearof birth. By entering a new year in one cell, and referencing that cell in calculated cell on EVERY LINE, I can arrive at an age for the child. I print a postcard and a list every week after sorting, extracting and creating a new workbook EVERY week for that week's birthdays.
At a radio station I used to work for, I did all that in access simply by entering a "EnterShowDate" variable and Access did the rest.
I've had quite a bit of success designing simple queries, but the query that did the selection and calculation of age based on the Child's birthdate and the "EnterShowDate" has eluded me. (A microsoft employee helped me over the phone one day for free). Since then, I discovered that that type of help is taboo for MS employees.
Given the variables of:
BIRTHDATE - the month, day and year of the child's birth -and-
ENTERSHOWDATE - the day that begins the birthday club (entered as a variable when the query is initiated)
1. Could someone help me develop a query that would extract the proper birthday club entries based on the month and day of the birthdate?
The Birthday Club is read on a Saturday and runs through the following Friday so the range would be BETWEEN (EnterShowDate and EnterShowDate+6) inclusive.
2. Could someone help me figure out a way to calculate the age of the child based on the year of EnterShowDate and BIRTHDATE? The calculation needs to work over the transition of Dec 31 to Jan1.
Given the proper syntax, I can design the resulting reports (my script and the postcards), I'm just too dense to get the syntax of working with dates (believe me I've tried).
Any help would be appreciated.
This is positively the COOLEST forum on the web in a very geeky way.
-MrRadio915
PS - This would be helpful for any organization who wishes to recognize birthdays in a timely manner.
Presently I have the data in an excel workbook and have individual columns for M, D and Yearof birth. By entering a new year in one cell, and referencing that cell in calculated cell on EVERY LINE, I can arrive at an age for the child. I print a postcard and a list every week after sorting, extracting and creating a new workbook EVERY week for that week's birthdays.
At a radio station I used to work for, I did all that in access simply by entering a "EnterShowDate" variable and Access did the rest.
I've had quite a bit of success designing simple queries, but the query that did the selection and calculation of age based on the Child's birthdate and the "EnterShowDate" has eluded me. (A microsoft employee helped me over the phone one day for free). Since then, I discovered that that type of help is taboo for MS employees.
Given the variables of:
BIRTHDATE - the month, day and year of the child's birth -and-
ENTERSHOWDATE - the day that begins the birthday club (entered as a variable when the query is initiated)
1. Could someone help me develop a query that would extract the proper birthday club entries based on the month and day of the birthdate?
The Birthday Club is read on a Saturday and runs through the following Friday so the range would be BETWEEN (EnterShowDate and EnterShowDate+6) inclusive.
2. Could someone help me figure out a way to calculate the age of the child based on the year of EnterShowDate and BIRTHDATE? The calculation needs to work over the transition of Dec 31 to Jan1.
Given the proper syntax, I can design the resulting reports (my script and the postcards), I'm just too dense to get the syntax of working with dates (believe me I've tried).
Any help would be appreciated.
This is positively the COOLEST forum on the web in a very geeky way.
-MrRadio915
PS - This would be helpful for any organization who wishes to recognize birthdays in a timely manner.