marklane2001
Registered User.
- Local time
- Today, 20:36
- Joined
- Sep 16, 2008
- Messages
- 15
Hi,
I currently have a database with a pupil table and within that table there is a date of birth field (DOB). What I would like to do is when entering the application, to have a button which navgates the user to a birthday page. This page contains a list box (lst1) which displays people who's birthday it is say 2 weeks before the actual date
What I then want to do is to be able to update when a card has been sent out so they are not displayed in the list anymore. I would assume I would need a flag of some description but this would need to be deleted after the date.
My actual questions are.
1) Does anyone know of an sample database which covers any of the above
2) if not then could somebody please advise the SQL to achieve the above listbox to display only birthdays that are occuring in 2 weeks or less and do not have the flag (if the card has already been sent out)
3) How and when I delete the flag so it picks the brithday up next year.
Sorry, I know it's a lot but I am completely in the dark when it comes to date functions
I currently have a database with a pupil table and within that table there is a date of birth field (DOB). What I would like to do is when entering the application, to have a button which navgates the user to a birthday page. This page contains a list box (lst1) which displays people who's birthday it is say 2 weeks before the actual date
What I then want to do is to be able to update when a card has been sent out so they are not displayed in the list anymore. I would assume I would need a flag of some description but this would need to be deleted after the date.
My actual questions are.
1) Does anyone know of an sample database which covers any of the above
2) if not then could somebody please advise the SQL to achieve the above listbox to display only birthdays that are occuring in 2 weeks or less and do not have the flag (if the card has already been sent out)
3) How and when I delete the flag so it picks the brithday up next year.
Sorry, I know it's a lot but I am completely in the dark when it comes to date functions
