In the datasheet, is it possible to format the data in a field in a summary record, but not the corresponding data in the underlying records?
I am running a simple summary procedure that groups sales by month. The summary record in the date field pulls the date of the last record in that month. Rather than displaying that date in the summary record, I’d prefer to display the month.
Here’s a screenshot of the date summary records:
I’d prefer to display:
In the datasheet, can I apply a “Month” date pattern to the Date field in just the summary records?
If not, I presume creating a form is a solution.