databasedev.co.uk - database solutions and downloads for microsoft access

Query the Day from a Date field in Microsoft Access

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:

Format([YourDateField],"dddd")

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.