Format Date as Day. Mon, Tue, Wed etc

I have no idea what I am doing wrong here.



I have a Query.



DateTracked is a field from the Table. It is of Data Type Date/Time, Formatted as Medium Date.



There are other Fields. Like Breakfast, Lunch and Dinner.



Problem.



I want to display in a separate Column "DateTracked" as a day of the week.



I have the following:



MyDate: Format ([DateTracked], "ddd")



This should display the day of the week as Mon, Tue, Wed etc.



What is it that I am doing wrong.



:banghead:

Format Date as Day. Mon, Tue, Wed etc