G Guest Oct 23, 2003 #1 I am new to the database world and am trying to organize employee records. Is there a way to Query or Filter the database to return all of the birthdays that will fall within a given month.
I am new to the database world and am trying to organize employee records. Is there a way to Query or Filter the database to return all of the birthdays that will fall within a given month.
A Allen Browne Oct 23, 2003 #2 Type a calculated field into the query that returns the person's birthday this year: Birthday: DateSerial(Year(Date()), Month([DOB]), Day([DOB])) -- Allen Browne - Microsoft MVP. Perth, Western Australia. Reply to group, rather than allenbrowne at mvps dot org. awente said: I am new to the database world and am trying to organize employee records. Click to expand... Is there a way to Query or Filter the database to return all of the birthdays that will fall within a given month.
Type a calculated field into the query that returns the person's birthday this year: Birthday: DateSerial(Year(Date()), Month([DOB]), Day([DOB])) -- Allen Browne - Microsoft MVP. Perth, Western Australia. Reply to group, rather than allenbrowne at mvps dot org. awente said: I am new to the database world and am trying to organize employee records. Click to expand... Is there a way to Query or Filter the database to return all of the birthdays that will fall within a given month.
