E
elizabeth367
I need some help with a Join Query I just created and hopefully I can explain
everything perfectly.
I am creating a comparison Overtime Report based on six months from two
different years. The report is going to show the Overtime Code (i.e. reason
overtime was worked) and the total amount of hours all employees worked that
particular code.
I originally had a problem when I created another query to show these
codes/hours. The query was not showing the Overtime Codes and hours worked
if a particular overtime code was not worked in both years (meaning if
overtime hours were worked for a media detail in 2007 but not 2008, this
query would not show the overtime code media detail at all).
Therefore, I created a join query based on a query for 2007 and one for 2008.
That worked perfectly however, now one of my years is not alphabetized.
Well it is alphabetized but all the Overtime Codes for say 2008 that were not
used in 2007 are alphabetized amongst themselves at the top of the query and
then the list continues with the rest of the codes that were used in 2007 and
they are alphabetized and lined up with the 2007 codes.
Example:
2007
2008
Assist Other Department 25.5
Callout 252.5
Media Detail 18.5
Administrative 158.75
Administrative 175.25
Booking 75.0
Booking 89.25
Paperwork 63.5
Training 21.25
Training 85.75
I hope this makes sense and someone is able to offer their assistance. If
you need more information from me, please don't hesitate to ask.
Thank you,
Elizabeth
everything perfectly.
I am creating a comparison Overtime Report based on six months from two
different years. The report is going to show the Overtime Code (i.e. reason
overtime was worked) and the total amount of hours all employees worked that
particular code.
I originally had a problem when I created another query to show these
codes/hours. The query was not showing the Overtime Codes and hours worked
if a particular overtime code was not worked in both years (meaning if
overtime hours were worked for a media detail in 2007 but not 2008, this
query would not show the overtime code media detail at all).
Therefore, I created a join query based on a query for 2007 and one for 2008.
That worked perfectly however, now one of my years is not alphabetized.
Well it is alphabetized but all the Overtime Codes for say 2008 that were not
used in 2007 are alphabetized amongst themselves at the top of the query and
then the list continues with the rest of the codes that were used in 2007 and
they are alphabetized and lined up with the 2007 codes.
Example:
2007
2008
Assist Other Department 25.5
Callout 252.5
Media Detail 18.5
Administrative 158.75
Administrative 175.25
Booking 75.0
Booking 89.25
Paperwork 63.5
Training 21.25
Training 85.75
I hope this makes sense and someone is able to offer their assistance. If
you need more information from me, please don't hesitate to ask.
Thank you,
Elizabeth