Sorting Dates

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?
 
K

KARL DEWEY

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?
 
Top