Grouping By Date

[Guest]

I am working on data that was appended into my table from an Excel file. The
field name is [Approval Date], it has a Date/Time data type with a short date
format. I believe the data was generated from a NOW function in Excel. The
Access table displays the approval date as mm/dd/yyyy, but when you click in
the field it displays mm/dd/yyyy hh:mm. When I use the Totals feature on
this field to group by Approval date, it groups records by the date & time of
the approval. Is there a way that I can group this data by just the month,
day, year and skip the grouping by time? Thanks.

 

[John W. Vinson]

I am working on data that was appended into my table from an Excel file. The
field name is [Approval Date], it has a Date/Time data type with a short date
format. I believe the data was generated from a NOW function in Excel. The
Access table displays the approval date as mm/dd/yyyy, but when you click in
the field it displays mm/dd/yyyy hh:mm. When I use the Totals feature on
this field to group by Approval date, it groups records by the date & time of
the approval. Is there a way that I can group this data by just the month,
day, year and skip the grouping by time? Thanks.

Add a calculated field to the query:

JustTheDate: Datevalue([Approval Date])

To avoid this problem in the future initialize the field using the Date()
function (date only) rather than Now() (date and time).

John W. Vinson [MVP]