need help creating date related query

[mish via AccessMonster.com]

I have a table that contain personal information of a number of peoples and
the table have a birthdate field which contain data of the date of birth and
the time of birth of a person . Now let say my birhdate in the record is
(12/2/1989 23:36:50)

and i would like to create a query that show the peoples who's age difference
with my age is less than 1 year. if it is too complicated to include the
calauction of the time in the expression then just ignore the time and show
only "age difference less than 1 year"

Thanks in advance

 

[Guest]

Use this as criteria --
Between DateAdd("d",-365,#12/2/1989#) And DateAdd("d",365,#12/2/1989#)

 

[kingston via AccessMonster.com]

Use a criteria for the birthdate field like:

#12/2/1988 23:36:50# AND <#12/2/1990 23:36:50#

 

[fredg]

I have a table that contain personal information of a number of peoples and
the table have a birthdate field which contain data of the date of birth and
the time of birth of a person . Now let say my birhdate in the record is
(12/2/1989 23:36:50)

and i would like to create a query that show the peoples who's age difference
with my age is less than 1 year. if it is too complicated to include the
calauction of the time in the expression then just ignore the time and show
only "age difference less than 1 year"

Thanks in advance

In a query:
Age: DateDiff("yyyy",[DOB],#12/2/1989#)-IIf(Format([DOB],"mmdd")

Format(#12/2/1989#,"mmdd"),1,0)

As criteria on this field, write:
Between 0 and -1

You should get ages of less than 1 year older through less than year
younger.

If you wish to include the time of day of your birth in the
calculation, just include it as #12/2/1989 11:36:50 PM#

Then change the code to:
DateDiff("yyyy",[DOB],#12/2/1989#)-IIf(Format([DOB],"mmdd hhnnss")

 

[mish via AccessMonster.com]

I have a table that contain personal information of a number of peoples and
the table have a birthdate field which contain data of the date of birth and

[quoted text clipped - 7 lines]

Thanks in advance

In a query:
Age: DateDiff("yyyy",[DOB],#12/2/1989#)-IIf(Format([DOB],"mmdd")

Format(#12/2/1989#,"mmdd"),1,0)

As criteria on this field, write:
Between 0 and -1

You should get ages of less than 1 year older through less than year
younger.

If you wish to include the time of day of your birth in the
calculation, just include it as #12/2/1989 11:36:50 PM#

Then change the code to:
DateDiff("yyyy",[DOB],#12/2/1989#)-IIf(Format([DOB],"mmdd hhnnss")

Format(#12/2/1989 11:36:50 PM#,"mmdd hhnnss"),1,0)

thank you so much you guys are really helpful

 

[mish via AccessMonster.com]

I have a table that contain personal information of a number of peoples and
the table have a birthdate field which contain data of the date of birth and

[quoted text clipped - 7 lines]

Thanks in advance

In a query:
Age: DateDiff("yyyy",[DOB],#12/2/1989#)-IIf(Format([DOB],"mmdd")

Format(#12/2/1989#,"mmdd"),1,0)

As criteria on this field, write:
Between 0 and -1

You should get ages of less than 1 year older through less than year
younger.

If you wish to include the time of day of your birth in the
calculation, just include it as #12/2/1989 11:36:50 PM#

Then change the code to:
DateDiff("yyyy",[DOB],#12/2/1989#)-IIf(Format([DOB],"mmdd hhnnss")

Format(#12/2/1989 11:36:50 PM#,"mmdd hhnnss"),1,0)

i cannot enter this into field: it said "the expression you entered has a
function containing the wrong number of arguments
Age: DateDiff("yyyy",[DOB],#12/2/1989#)-IIf(Format([DOB],"mmdd")

 

[fredg]

I have a table that contain personal information of a number of peoples and
the table have a birthdate field which contain data of the date of birth and

[quoted text clipped - 7 lines]

Thanks in advance

In a query:
Age: DateDiff("yyyy",[DOB],#12/2/1989#)-IIf(Format([DOB],"mmdd")

Format(#12/2/1989#,"mmdd"),1,0)

As criteria on this field, write:
Between 0 and -1

You should get ages of less than 1 year older through less than year
younger.

If you wish to include the time of day of your birth in the
calculation, just include it as #12/2/1989 11:36:50 PM#

Then change the code to:
DateDiff("yyyy",[DOB],#12/2/1989#)-IIf(Format([DOB],"mmdd hhnnss")

Format(#12/2/1989 11:36:50 PM#,"mmdd hhnnss"),1,0)

i cannot enter this into field: it said "the expression you entered has a
function containing the wrong number of arguments
Age: DateDiff("yyyy",[DOB],#12/2/1989#)-IIf(Format([DOB],"mmdd")

You seem to have left off the rest of the expression.

Format(#12/2/1989#,"mmdd"),1,0)

it should all be on one line.