Access 2007 Query

marc515151 · 10-07-2009, 04:52 PM

I am trying to run a date of birth query.

I have the date of customer birthday and i need to query whos birthday is coming up in the next two weeks.

date saved as 20/10/1986 as an example and since that birthday is within the next two weeks from today i want it displayed when the query is run.

Does anyone know what i should put it the criteria to achieve these results. The query just has to look at the date and month at the minute.

Thanks,
Marc

**2xgrump** · 10-07-2009, 05:22 PM

I would use this formula: >(today's Date)<(Date 2 wks from now)

marc515151 · 10-07-2009, 05:56 PM

this has to be idiot proof so i dont want to have to change the criteria all the time, i want a set formula that will look at todays date and the next 2 weeks dates and do the query, dont want to have to change it all the time as it wont be me using the database

marc515151 · 10-09-2009, 01:05 PM

right lets change this slightly.

i want one query that will look at all records and i want the query to look something like this but i dont no how to right it

greater than (dob taken from table automatically) but less than (manually entered date)

so i guess it should look simlar to this.

>dob()<[enter date]

its the first bit where it automatically checks the date that i dont no how to do it

marc515151 · 10-09-2009, 02:29 PM

but then again that wouldnt work cuz the birthday will always be between date of birth and today...how do i get it to not look at the year? or to get it to set the year to the current year and will change to the current year each time the year changes

marc515151 · 10-10-2009, 05:51 PM

im sorry but can anyone help me do this? i was meant to have this finished today.

10-07-2009, 04:52 PM	#1 (permalink)
marc515151 Registered User Join Date: Oct 2009 Posts: 5 OS: XP Pro	Access 2007 Query I am trying to run a date of birth query. I have the date of customer birthday and i need to query whos birthday is coming up in the next two weeks. date saved as 20/10/1986 as an example and since that birthday is within the next two weeks from today i want it displayed when the query is run. Does anyone know what i should put it the criteria to achieve these results. The query just has to look at the date and month at the minute. Thanks, Marc

10-07-2009, 05:22 PM	#2 (permalink)
2xgrump Mentor Networking Forums Join Date: Aug 2009 Posts: 1,051 OS: Vista-sp2/Win2003Server-R2/SBS2003/XP-sp3	Re: Access 2007 Query I would use this formula: >(today's Date)<(Date 2 wks from now) __________________ Networking Forums "Peace" RD

10-07-2009, 05:56 PM	#3 (permalink)
marc515151 Registered User Join Date: Oct 2009 Posts: 5 OS: XP Pro	Re: Access 2007 Query this has to be idiot proof so i dont want to have to change the criteria all the time, i want a set formula that will look at todays date and the next 2 weeks dates and do the query, dont want to have to change it all the time as it wont be me using the database

10-09-2009, 01:05 PM	#4 (permalink)
marc515151 Registered User Join Date: Oct 2009 Posts: 5 OS: XP Pro	Re: Access 2007 Query right lets change this slightly. i want one query that will look at all records and i want the query to look something like this but i dont no how to right it greater than (dob taken from table automatically) but less than (manually entered date) so i guess it should look simlar to this. >dob()<[enter date] its the first bit where it automatically checks the date that i dont no how to do it

10-09-2009, 02:29 PM	#5 (permalink)
marc515151 Registered User Join Date: Oct 2009 Posts: 5 OS: XP Pro	Re: Access 2007 Query but then again that wouldnt work cuz the birthday will always be between date of birth and today...how do i get it to not look at the year? or to get it to set the year to the current year and will change to the current year each time the year changes

10-10-2009, 05:51 PM	#6 (permalink)
marc515151 Registered User Join Date: Oct 2009 Posts: 5 OS: XP Pro	Re: Access 2007 Query im sorry but can anyone help me do this? i was meant to have this finished today.