have query grab 2 different method

  • Thread starter Thread starter _Bigred
  • Start date Start date
B

_Bigred

Method 1:
Have a query grab every record that has a birthday that matches (your)
computer's date "Month & Day"?

Have a query grab every record that has a birthday that matches (your)
computer's month date?

TIA,
_Bigred
 
1) SELECT * FROM MyTable WHERE Format([DOB], "mmdd") = Format(Date(),
"mmdd")

2) SELECT * FROM MyTable WHERE Month([DOB]) = Month(Date())
 
Back
Top