Question: how to change date format to dd/mm/yyyy in 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.