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 evie-gray_6097a8f3445c1 May 2021