Month and Day only

  • Thread starter Thread starter Maz
  • Start date Start date
M

Maz

I would like to run a query which selects all the dates from a date of Birth
field (dob) that picks out the birthdays of that date irrespective of the
year.

Thanks in advance to anyone that can help me.

Maz T
 
Maz,

Does it give what you want by putting a calculated field in a query,
like this...
Birthday: Format([dob],"d mmm")
 
Yes that will do the trick I think Thanks


Steve Schapel said:
Maz,

Does it give what you want by putting a calculated field in a query,
like this...
Birthday: Format([dob],"d mmm")

--
Steve Schapel, Microsoft Access MVP

I would like to run a query which selects all the dates from a date of Birth
field (dob) that picks out the birthdays of that date irrespective of the
year.

Thanks in advance to anyone that can help me.

Maz T
Click to expand...
Click to expand...
 
Back
Top