|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
#1
November 13th, 2008, 02:20 PM
posted to microsoft.public.access.reports
|
|||
|
|||
Sorting Dates
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 sheet 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? 
|
|
#2
November 13th, 2008, 04:30 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Sorting Dates
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 sheet 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?
|
|
#3
November 13th, 2008, 05:20 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Sorting Dates
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 sheet 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?
|
|
#4
November 13th, 2008, 05:29 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Sorting Dates
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 sheet 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?
|
|
#5
November 13th, 2008, 05:32 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Sorting Dates
Try reversing it.
-- KARL DEWEY Build a little - Test a little "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 sheet 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?
|
|
#6
November 13th, 2008, 05:34 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Sorting Dates
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 sheet 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?
|
|
#7
November 13th, 2008, 05:38 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Sorting Dates
Try reversing the entire sort?
"KARL DEWEY" wrote: Try reversing it. -- KARL DEWEY Build a little - Test a little "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 sheet 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?
|
|
#8
November 13th, 2008, 06:16 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Sorting Dates
If you look at the Record Source of the report in datasheet 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 sheet 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?
|
|
#9
November 13th, 2008, 06:27 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Sorting Dates
I had it centered.
"Duane Hookom" wrote: If you look at the Record Source of the report in datasheet 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 sheet 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?
|
|
#10
November 13th, 2008, 07:51 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Sorting Dates
You centered the values in a datasheet of a report? You are making Access way
too much work ;-) What is the SQL view of the record source of the report? -- Duane Hookom Microsoft Access MVP "Melinda" wrote: I had it centered. "Duane Hookom" wrote: If you look at the Record Source of the report in datasheet 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 sheet 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?
|
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
