Sorting Dates

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.

to allow for the selection of "Year, Qtr, Month, Week, Day, Hour, Min" as if SortKey1 was a normal date field?
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?

--
Build a little, test a little.


"iamnu" wrote:

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?