How to format Access crosstab column heading Date?

Question

Not familar with Access. WorkDate is column heading of crosstab query, and I click WorkDate field, it shows query property. Table field WorkDate format is Long, but not showing Long on crosstab query.

I would like WorkDate to include weekday information, something like: Mon Jan-4-2021 No need to be exactly same, but including weekday information

Thanks.

Here is file link (with some space in between, in case of not allowed in this forum): https://drive. google .com/ file/d/1RcVPqMNAXZ6HyN7Ly-3F2bqoOGhnbOtO/view?usp=sharing

Answer 1

Change WorkDate in the Column Heading column to Format([WorkDate],"ddd d-mmm-yyyy")

Keep in mind that Access will sort the Column Headings in alphabetic order, not in date order, so you'd get Fri - Mon - Sat - Sun - Thu - Tue - Wed.

An alternative that looks less traditional but will be sorted correctly would be Format([WorkDate],"yyyy-mm-dd ddd")

Remark: do not change WorkDate in the Where column.