Question: how to set date format in ms access query?
Answer: Open the query in Design View. Right-click the date field, and then click Properties. In the Property Sheet, select the format you want from the Format property list.