Sorting Dates

  • Thread starter Thread starter iamnu
  • Start date Start date
I

iamnu

In the Sorting and Grouping area, I have a Field/Expression called
SortKey1. I am populating SortKey1 with a date, depending on certain
parameters.

In the Group Properties for SortKey1, "Group On" only has "Each
Value", and "Prefix Characters".

How do I get the Group Properties for SortKey1 to allow for the
selection of "Year, Qtr, Month, Week, Day, Hour, Min" as if SortKey1
was a normal date field?
 
I am populating SortKey1 with a date, depending on certain parameters.
You did not give examples of what data the field will contain.
If Access can not decipher the data as a date then it cannot offer those
options.

Why not use two Sortkey fields, one with date or null data and the other
with the other type?
 
Back
Top