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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dates in Chronological Order 1
Sorting and Grouping 2
Grouping by Dates before & after Today's date 1
Sorting dates within groups. 2
Sorting Dates 8
Report By Name Order 1
How to Group on and Display WeekEnding Dates? 1
Sort order in report 2

Top