Using an expression in a Microsoft Access query design will enable you to find the day from a date field stored in the database table. This may be helpfull if you wish to monitor sales by a particular day of the week.
You can simply use the following Microsoft Access Format function to display the day:
The example below shows this to display what day a person was born on, by using the format function against the date of birth field:
Query design showing the Format function
Using this will now display the results, showing the day derived from the DateOfBirth field:
The results of the query, displaying the day from the date field.