Dates Queries

[Guest]

Is there a way to set up a birthdate query where Access would pull up anyone
whose age is 70 years old or above?

 

[Rick B]

Sure. Add a new column to your query to calculate age...
PersonAge:
DateDiff("yyyy",[Birthdate],Date())+(Format([Birthdate],"mmdd")>Format(Date(
),"mmdd"))



Then in the criteria put...

69

Hope that helps.


Rick B

 

[Rick B]

That second line should all be placed in the "Field:" of your query....

PersonAge: DateDiff("...





Rick B

Sure. Add a new column to your query to calculate age...
PersonAge:
DateDiff("yyyy",[Birthdate],Date())+(Format([Birthdate],"mmdd")>Format(Date(
),"mmdd"))



Then in the criteria put...

69

Hope that helps.


Rick B

Is there a way to set up a birthdate query where Access would pull up anyone
whose age is 70 years old or above?

 

[Douglas J. Steele]

Far better would be to figure out 70 years prior to today, and check for
birthdays prior to that.

WHERE [Birthdate] <= DateAdd("yyyy", -70, Date())

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Sure. Add a new column to your query to calculate age...
PersonAge:
DateDiff("yyyy",[Birthdate],Date())+(Format([Birthdate],"mmdd")>Format(Date(
),"mmdd"))



Then in the criteria put...

69

Hope that helps.


Rick B

Is there a way to set up a birthdate query where Access would pull up anyone
whose age is 70 years old or above?

 

[Chris2]

Is there a way to set up a birthdate query where Access would pull up anyone
whose age is 70 years old or above?

Sue,

SELECT *
FROM YourTable AS Y1
WHERE Y1.Birthdate <
DateSerial((Year(Date()) - 70), Month(Date()), Day(Date()))


Sincerely,

Chris O.