Jan 5, 2004 #1 PlsHlpKat IS-IT--Management Joined Feb 20, 2003 Messages 49 Location US How can I do a query by Birth month only using the birth date field? i.e. I need a report for all birthdays in January regardless of year.
How can I do a query by Birth month only using the birth date field? i.e. I need a report for all birthdays in January regardless of year.
Jan 5, 2004 #2 SuicidED MIS Joined May 22, 2003 Messages 232 Location GB Hi Format([yourfieldname],"mm" Upvote 0 Downvote
Jan 5, 2004 Thread starter #3 PlsHlpKat IS-IT--Management Joined Feb 20, 2003 Messages 49 Location US Thanks!! That worked! Upvote 0 Downvote
Jan 5, 2004 #4 WildHare MIS Joined Mar 1, 2002 Messages 1,801 Location US Or MONTH([Birthdate]) = 1 ... Jim Don't be sexist - Broads hate that. Another free Access forum: http://www.forumco.com/jmhareMore Access help stuff at http://www.jmhare.com/wildhare.htm Upvote 0 Downvote
Or MONTH([Birthdate]) = 1 ... Jim Don't be sexist - Broads hate that. Another free Access forum: http://www.forumco.com/jmhareMore Access help stuff at http://www.jmhare.com/wildhare.htm