RE: Sorting Dates

I had it centered.

"Duane Hookom" wrote:

If you look at the Record Source of the report in data*** view, does your
Seniority Date Hire field appear left or right aligned? If it is
left-aligned, it is text and will not sort properly in the report.

--
Duane Hookom
Microsoft Access MVP


"Melinda" wrote:

Back in the employee table I have the data type as a Date/Time field.
Possibly is that where my problem is? and then I have it formated in the form
as a "Short Date"
in the form and report.

"Duane Hookom" wrote:

When you state __sorting on a "Short Date"__ it raises a red flag. Can you
explain this?

Sort on the date field value, not on any formatting. Formats should be
applied only in the control in the report that displays the value. Send pure
data values to your report.

--
Duane Hookom
Microsoft Access MVP


"Melinda" wrote:

This is exactly how I have it sorting, but the 3rd sort which is the
Seniority Date/Hire Date seems to be where the trouble is. I have it
sorting on a "Short Date" from oldest to newest. When there are 3 employees
with the exact same total of overtime hours, the seniority dates are sorting
as 10/06/2003, 11/08/1999, and 01/17/1995. Should be the exact opposite.
"KARL DEWEY" wrote:

How would I go out about sorting the Seniority date properly?
I assume Seniority date is the hire date.
You must use the report Grouping and Sorting and select the three fields in
the order you stated. All would be in ascending order.
--
KARL DEWEY
Build a little - Test a little


"Melinda" wrote:

I have a report in which I have several layers of sorting. My first sort is
by Class No, 2nd sort is total hours of overtime from lowest to highest, and
my 3rd sort is by seniority Date.

My problem is in the 3rd sort. This report is an overtime callout ***
in which you are called to plow snow. I need it to sort by Class number,
within that class number the lowest balance of overtime hours and if two
employees have the same total in overtime hours I need it to put the first
employee with the most seniority at the top.

How would I go out about sorting the Seniority date properly?
.

Loading