By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,480 Members | 2,189 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,480 IT Pros & Developers. It's quick & easy.

Church Database

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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.