468,553 Members | 1,370 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,553 developers. It's quick & easy.

Church Database

Ok I have read a number of messages about this but am having trouble understanding it all.

This is what i need:

I have a list of birthdays for youth. I need to know (based on their birthday [BDate] what month it will be six months after that date.This is for interview purposes.
Naturally this is all based on month and day and not year.
I would like to have this automated to appear on a form so that I can click on a button and it will show me who is coming up for an interview next month. I would then like to print this out as a report.

I would liek to be able to cut and paste the code into SQL as I am still learning how to use the functions in Access.

Hope you can help me

--
Message posted via http://www.accessmonster.com
Nov 13 '05 #1
3 1416
I'm not sure I understand your question: you want to know what month it will
be six months after WHAT date?

Are you saying you want six months after their birthday this year? That
would be DateAdd("m", 6, DateSerial(Year(Date), Month([BDate]),
Day([Bdate])))

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Gaven via AccessMonster.com" <fo***@AccessMonster.com> wrote in message
news:da******************************@AccessMonste r.com...
Ok I have read a number of messages about this but am having trouble understanding it all.
This is what i need:

I have a list of birthdays for youth. I need to know (based on their birthday [BDate] what month it will be six months after that date.This is
for interview purposes. Naturally this is all based on month and day and not year.
I would like to have this automated to appear on a form so that I can click on a button and it will show me who is coming up for an interview next
month. I would then like to print this out as a report.
I would liek to be able to cut and paste the code into SQL as I am still learning how to use the functions in Access.
Hope you can help me

--
Message posted via http://www.accessmonster.com

Nov 13 '05 #2
Yes but where would I put that code.

I want to be able to have a result box with a date 6 months from the date of the person birhtday this year.

I need to know who is due for an interview six months after their birthday.

Example. Say I wanted to print a report today. I would like the report to have a section where it shows me anyone who needs to have an interview because its been six months from their birthday.
Youth have an interview every six months, so one will be on their birthday and the next will be six months later

--
Message posted via http://www.accessmonster.com
Nov 13 '05 #3
G F via AccessMonster.com wrote:
Yes but where would I put that code.

I want to be able to have a result box with a date 6 months from the date of the person birhtday this year.

I need to know who is due for an interview six months after their birthday.

Example. Say I wanted to print a report today. I would like the report to have a section where it shows me anyone who needs to have an interview because its been six months from their birthday.
Youth have an interview every six months, so one will be on their birthday and the next will be six months later

Instead of showing this, you could also filter the set to show just
those eligible for interview. Why decide manually if you can formalize
the decision and have it made by your tool?

If everyone in your table is to be interviewed every six months, and you
want a report with interviews for coming month (that is, today it would
show you the list for January), this expression:

datediff("m",bdate,dateadd("m",1,date)) mod 6

will return 0 for all candidates.
--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Cherrish Vaidiyan | last post: by
10 posts views Thread by TS | last post: by
21 posts views Thread by Merrill & Michele | last post: by
reply views Thread by Pastororits | last post: by
reply views Thread by NPC403 | last post: by
1 post views Thread by UniDue | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.