Comments

• it should work this way if i understand the given requirements. SELECT customer.*, Format([created_on],"mm/yyyy") AS formatted_created_on FROM customer WHERE (((Format([created_on],"mm/yyyy")) = "01/2013")) ORDER …

  in How to add date criteria to query in Access 2007? Comment by edward-graham_60bc4abbd27ec June 2021