Multiple labor codes per day

[collinjones]

Sorry for the laymen's terms here as I am entirely self taught and not well.


I have been tasked with taking labor information from Micros daily and reporting total hours worked by job code at each location(ultimetly making these codes total into a category; Kitchen, Front of House, Bar, Management which is another question but not the main one right now).

The hours pulled from the system gives all employees hours' within one time frame (yesterday, week-to date, or month to date)but no location. So I created a simple table listing the location for each employee and dump three daily hours tables in making four tables.

My problem is that sometimes a person works two or more job codes in a given day, week, or month. The daily hours table has lets say two codes for one person, server and bar. My query is giving me both codes twice with the correct respective hours(for example my hours table has two rows, one for server hours 18.15 and one for bar hours 19.11 and the query does add the locaiton but has 4 rows two for each job code).

Where am I going wrong.

 

[genomon]

Tray adding DISTINCT after the SELECT statement in your query.

It's always darkest before dawn. So if you're going to steal your
neighbor's newspaper, that's the time to do it.

 

[collinjones]

thank you so much. It worked perfectly. Now I have to get it working for the remaining queries.

What did I do by the way. Where can I learn these SQL commands?

 

[dhookom]

Where can I learn these SQL commands" try google [blue]SQL tutorials[/blue] or find a good book.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[genomon]

There are also some good faqs in the SQL Server programming forum. Publishers like Que & Wrox are good, as well as

http://www.justphukit.com/sql/sql-tutorials-1.php.

Have fun!

It's always darkest before dawn. So if you're going to steal your
neighbor's newspaper, that's the time to do it.

 

[collinjones]

Ok so I have now worked with Iquery to give me a easier table to work with.

I have every hour worked of every day from every location for every employee at every job code. Each in a separte row.

I want to come up with a query that will allow me to, in essence, sort by location then by job code and then sum the hours worked under each code for the day. Then i need to compare the hours worked by yesterday, week to date, and month to date at each location.

As a true beginner to SQL this seems a bit daunting. Can someone kinda push me towards the right place to start and maybe I can learn from there.

 

[dhookom]

Please provide some sample data with real table and field names. Then provide the desired final display of this data and if it will be "rendered" in a form or report.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[collinjones]

can you attach files to these replies? or should I cut paste....

First is the desired result....second part of the raw data
Daily Labor Report
10/10/07 Job Code Easton MD Edgewater MD LaPlata MD Salisbury MD BWI Airport Laurel MD Towson MD Verizon Center Total District 1 District 2
(1) Bar 0.0 0.0 0.0
(2) Bar Back 0.0 0.0 0.0
(3) Bar Server 0.0 0.0 0.0
(4) Bar/Server/6 0.0 0.0 0.0
(5) Bar Total 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
(6) Bus 0.0 0.0 0.0
(7) Cook 0.0 0.0 0.0
(8) Dish 0.0 0.0 0.0
(9) Expo 0.0 0.0 0.0
(10) Kitchen Total 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
(11) Host/Hostess 0.0 0.0 0.0
(12) Retail/To Go/13 0.0 0.0 0.0
(13) Runner 0.0 0.0 0.0
(14) Security 0.0 0.0 0.0
(15) Server 0.0 0.0 0.0
(16) Server Train 0.0 0.0 0.0
(17) FOH Total 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
(18) Admin 0.0 0.0 0.0
(19) Hourly Mgr/7 0.0 0.0 0.0
(20) Manager 0.0 0.0 0.0
(21) Salary Mgr 0.0 0.0 0.0
(22) Mngt Total 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
(23) Total 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0


Week-to-date Labor Report
10/10/07 Job Code Easton MD Edgewater MD LaPlata MD Salisbury MD BWI Airport Laurel MD Towson MD Verizon Center Total District 1 District 2
(1) Bar 0.0 0.0 0.0
(2) Bar Back 0.0 0.0 0.0
(3) Bar Server 0.0 0.0 0.0
(4) Bar/Server/6 0.0 0.0 0.0
(5) Bar Total 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
(6) Bus 0.0 0.0 0.0
(7) Cook 0.0 0.0 0.0
(8) Dish 0.0 0.0 0.0
(9) Expo 0.0 0.0 0.0
(10) Kitchen Total 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
(11) Host/Hostess 0.0 0.0 0.0
(12) Retail/To Go/13 0.0 0.0 0.0
(13) Runner 0.0 0.0 0.0
(14) Security 0.0 0.0 0.0
(15) Server 0.0 0.0 0.0
(16) Server Train 0.0 0.0 0.0
(17) FOH Total 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
(18) Admin 0.0 0.0 0.0
(19) Hourly Mgr/7 0.0 0.0 0.0
(20) Manager 0.0 0.0 0.0
(21) Salary Mgr 0.0 0.0 0.0
(22) Mngt Total 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
(23) Total 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0

Month-to-date Labor Report
10/10/07 Job Code Easton MD Edgewater MD LaPlata MD Salisbury MD BWI Airport Laurel MD Towson MD Verizon Center Total District 1 District 2
(1) Bar 0.0 0.0 0.0
(2) Bar Back 0.0 0.0 0.0
(3) Bar Server 0.0 0.0 0.0
(4) Bar/Server/6 0.0 0.0 0.0
(5) Bar Total 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
(6) Bus 0.0 0.0 0.0
(7) Cook 0.0 0.0 0.0
(8) Dish 0.0 0.0 0.0
(9) Expo 0.0 0.0 0.0
(10) Kitchen Total 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
(11) Host/Hostess 0.0 0.0 0.0
(12) Retail/To Go/13 0.0 0.0 0.0
(13) Runner 0.0 0.0 0.0
(14) Security 0.0 0.0 0.0
(15) Server 0.0 0.0 0.0
(16) Server Train 0.0 0.0 0.0
(17) FOH Total 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
(18) Admin 0.0 0.0 0.0
(19) Hourly Mgr/7 0.0 0.0 0.0
(20) Manager 0.0 0.0 0.0
(21) Salary Mgr 0.0 0.0 0.0
(22) Mngt Total 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
(23) Total 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0


Business Date Employee Last Name Job Code Name Location Name Total Hours (Sum)
10/1/2007 Miller Bar BWI Airport 8.32
10/1/2007 Lucas Bar BWI Airport 7.7
10/1/2007 Dziwulski Bar BWI Airport 7.51
10/2/2007 Lucas Bar BWI Airport 7.9
10/2/2007 Sabella Bar BWI Airport 8.47
10/2/2007 Selckmann Bar BWI Airport 9.46
10/3/2007 Sabella Bar BWI Airport 8.78
10/3/2007 Osullivan Bar BWI Airport 9.78
10/3/2007 Dziwulski Bar BWI Airport 7.64
10/4/2007 Dziwulski Bar BWI Airport 8.54
10/4/2007 Selckmann Bar BWI Airport 8.73
10/4/2007 Sabella Bar BWI Airport 8.8
10/5/2007 Dziwulski Bar BWI Airport 8.26
10/5/2007 Osullivan Bar BWI Airport 9.96
10/5/2007 Sabella Bar BWI Airport 9.02
10/6/2007 Selckmann Bar BWI Airport 8.32
10/6/2007 Clark Bar BWI Airport 7.84
10/6/2007 Osullivan Bar BWI Airport 9.02
10/7/2007 Osullivan Bar BWI Airport 8.16
10/7/2007 Fantinato Bar BWI Airport 6.86
10/7/2007 Clark Bar BWI Airport 9.31
10/8/2007 Dziwulski Bar BWI Airport 10.57
10/8/2007 Osullivan Bar BWI Airport 8.21
10/9/2007 Sabella Bar BWI Airport 8.25
10/9/2007 Osullivan Bar BWI Airport 6.97
10/9/2007 Selckmann Bar BWI Airport 9.1
10/10/2007 Sabella Bar BWI Airport 8.37
10/10/2007 Selckmann Bar BWI Airport 7.09
10/10/2007 Dziwulski Bar BWI Airport 9.46
10/5/2007 Dziwulski Bar Train BWI Airport 0
10/1/2007 Harting Cook BWI Airport 6.09
10/1/2007 Rollins Cook BWI Airport 7.39
10/1/2007 Brock Cook BWI Airport 6.97
10/1/2007 Vaughn Cook BWI Airport 7.85
10/1/2007 Devaughn Cook BWI Airport 10.46
10/2/2007 Vaughn Cook BWI Airport 5.48
10/2/2007 Devaughn Cook BWI Airport 7.7
10/2/2007 Rollins Cook BWI Airport 8.51
10/2/2007 Fields Cook BWI Airport 7.45
10/2/2007 Elliott Cook BWI Airport 8.29
10/2/2007 Brock Cook BWI Airport 8.01
10/2/2007 Simmons Cook BWI Airport 6.14
10/3/2007 Elliott Cook BWI Airport 7.66
10/3/2007 Fields Cook BWI Airport 7.77
10/3/2007 Devaughn Cook BWI Airport 9.36
10/3/2007 Brock Cook BWI Airport 8.84
10/3/2007 Rollins Cook BWI Airport 8.41
10/3/2007 Vaughn Cook BWI Airport 6.8
10/4/2007 brooks Cook BWI Airport 7.73
10/4/2007 Simmons Cook BWI Airport 8.51
10/4/2007 Harting Cook BWI Airport 8.11
10/4/2007 Fields Cook BWI Airport 7.63
10/4/2007 Devaughn Cook BWI Airport 9.27
10/4/2007 Elliott Cook BWI Airport 8.84
10/4/2007 Brock Cook BWI Airport 6.02
10/5/2007 Simmons Cook BWI Airport 8.34
10/5/2007 Harting Cook BWI Airport 6.96
10/5/2007 Elliott Cook BWI Airport 9.33
10/5/2007 Rollins Cook BWI Airport 8.67
10/5/2007 Motley Cook BWI Airport 7.69
10/5/2007 Brock Cook BWI Airport 7.9
10/5/2007 Vaughn Cook BWI Airport 7.77
10/6/2007 Fields Cook BWI Airport 5.3
10/6/2007 brooks Cook BWI Airport 5.15
10/6/2007 Motley Cook BWI Airport 7.48
10/6/2007 Harting Cook BWI Airport 5.74
10/6/2007 Rollins Cook BWI Airport 7.52
10/7/2007 Fields Cook BWI Airport 6.48
10/7/2007 brooks Cook BWI Airport 5.74
10/7/2007 Brock Cook BWI Airport 7.96
10/7/2007 Motley Cook BWI Airport 7.61
10/7/2007 Harting Cook BWI Airport 7.58
10/7/2007 Devaughn Cook BWI Airport 9.87
10/8/2007 Devaughn Cook BWI Airport 10.1
10/8/2007 Fields Cook BWI Airport 7.06
10/8/2007 Harting Cook BWI Airport 7.16
10/8/2007 Simmons Cook BWI Airport 7.42
10/8/2007 Brock Cook BWI Airport 8.34
10/9/2007 Simmons Cook BWI Airport 6.34
10/9/2007 Gibson Cook BWI Airport 7.17
10/9/2007 Brown Cook BWI Airport 8.27
10/9/2007 Brock Cook BWI Airport 8.28
10/9/2007 Devaughn Cook BWI Airport 9.6
10/9/2007 Fields Cook BWI Airport 6.42
10/10/2007 Harting Cook BWI Airport 7.4
10/10/2007 Elliott Cook BWI Airport 9.04
10/10/2007 Devaughn Cook BWI Airport 8.55
10/10/2007 Rollins Cook BWI Airport 8.34
10/10/2007 Gibson Cook BWI Airport 5.82
10/10/2007 Brock Cook BWI Airport 7.54
10/10/2007 Simmons Cook BWI Airport 3.21
10/1/2007 King Dish BWI Airport 7.34
10/1/2007 brooks Dish BWI Airport 3.14
10/2/2007 Wilson Dish BWI Airport 7.52
10/2/2007 brooks Dish BWI Airport 7.32
10/3/2007 Wilson Dish BWI Airport 7.95
10/3/2007 brooks Dish BWI Airport 7.86
10/4/2007 King Dish BWI Airport 7.14
10/4/2007 Wilson Dish BWI Airport 8.38
10/5/2007 King Dish BWI Airport 8.29
10/5/2007 Wilson Dish BWI Airport 5.98
10/6/2007 King Dish BWI Airport 4.17
10/7/2007 King Dish BWI Airport 7.53
10/8/2007 brooks Dish BWI Airport 8.74
10/8/2007 King Dish BWI Airport 6.84
10/8/2007 Wilson Dish BWI Airport 9.36
10/9/2007 brooks Dish BWI Airport 8.57
10/9/2007 Wilson Dish BWI Airport 7.77
10/10/2007 Wilson Dish BWI Airport 7.11
10/10/2007 brooks Dish BWI Airport 7.27
10/1/2007 Johnson Retail/To Go/13 BWI Airport 2.48
10/1/2007 fletcher Retail/To Go/13 BWI Airport 5
10/1/2007 Booker Retail/To Go/13 BWI Airport 6.52
10/2/2007 Booker Retail/To Go/13 BWI Airport 7.67
10/3/2007 Booker Retail/To Go/13 BWI Airport 7.7
10/4/2007 Booker Retail/To Go/13 BWI Airport 7.89
10/5/2007 Booker Retail/To Go/13 BWI Airport 7.64
10/7/2007 fletcher Retail/To Go/13 BWI Airport 6.2
10/8/2007 fletcher Retail/To Go/13 BWI Airport 6.24
10/8/2007 Booker Retail/To Go/13 BWI Airport 7.33
10/9/2007 Booker Retail/To Go/13 BWI Airport 7.72
10/10/2007 fletcher Retail/To Go/13 BWI Airport 8.52
10/1/2007 Hewitt Salary Mgr BWI Airport 11
10/1/2007 Smith Salary Mgr BWI Airport 8.63
10/1/2007 Waskey Salary Mgr BWI Airport 6.09
10/2/2007 Smith Salary Mgr BWI Airport 9.71
10/2/2007 Hewitt Salary Mgr BWI Airport 1.02
10/2/2007 Waskey Salary Mgr BWI Airport 8.68
10/3/2007 Cammarata Salary Mgr BWI Airport 15.25
10/3/2007 Hewitt Salary Mgr BWI Airport 9.91
10/3/2007 Waskey Salary Mgr BWI Airport 7.54
10/4/2007 Hewitt Salary Mgr BWI Airport 10.03
10/4/2007 Cammarata Salary Mgr BWI Airport 15.38
10/4/2007 Waskey Salary Mgr BWI Airport 9.26
10/5/2007 Waskey Salary Mgr BWI Airport 8.03
10/5/2007 Smith Salary Mgr BWI Airport 9.92
10/5/2007 Hewitt Salary Mgr BWI Airport 9.7
10/6/2007 Smith Salary Mgr BWI Airport 9.47
10/6/2007 Cammarata Salary Mgr BWI Airport 12.34
10/7/2007 Smith Salary Mgr BWI Airport 9.58
10/7/2007 Cammarata Salary Mgr BWI Airport 11.98
10/7/2007 Hewitt Salary Mgr BWI Airport 9.38
10/8/2007 Waskey Salary Mgr BWI Airport 5.73
10/8/2007 Smith Salary Mgr BWI Airport 10.49
10/9/2007 Hewitt Salary Mgr BWI Airport 9.58
10/9/2007 Smith Salary Mgr BWI Airport 9.54
10/9/2007 Waskey Salary Mgr BWI Airport 9.14
10/10/2007 Cammarata Salary Mgr BWI Airport 4.79
10/10/2007 Smith Salary Mgr BWI Airport 9.46
10/10/2007 Hewitt Salary Mgr BWI Airport 10.32
10/1/2007 Altmire Server BWI Airport 7.89
10/1/2007 Jacobs Server BWI Airport 6.48
10/1/2007 Lupinek Server BWI Airport 7.85
10/1/2007 Fantinato Server BWI Airport 7.76
10/1/2007 Carter Server BWI Airport 9.31
10/1/2007 Laribee Server BWI Airport 7.7
10/1/2007 Zimmerman Server BWI Airport 6.36
10/1/2007 Elliott Server BWI Airport 6.61
10/2/2007 Altmire Server BWI Airport 4.29
10/2/2007 Zimmerman Server BWI Airport 8.23
10/2/2007 Elliott Server BWI Airport 4.32
10/2/2007 Jacobs Server BWI Airport 6.73
10/2/2007 Lupinek Server BWI Airport 8.02
10/2/2007 Carter Server BWI Airport 9.17
10/2/2007 Fantinato Server BWI Airport 6.59
10/2/2007 Eifert Server BWI Airport 7.95
10/3/2007 Clark Server BWI Airport 8.54
10/3/2007 Zimmerman Server BWI Airport 6.29
10/3/2007 Jacobs Server BWI Airport 8.64
10/3/2007 Carter Server BWI Airport 8.96
10/3/2007 Elliott Server BWI Airport 8.18
10/3/2007 Fantinato Server BWI Airport 6.53
10/3/2007 Eifert Server BWI Airport 8.66
10/3/2007 Lupinek Server BWI Airport 6.42
10/4/2007 Carter Server BWI Airport 9.14
10/4/2007 Eifert Server BWI Airport 6.9
10/4/2007 Altmire Server BWI Airport 8.76
10/4/2007 Jacobs Server BWI Airport 9.11
10/4/2007 Mcelroy Server BWI Airport 9.13
10/4/2007 Elliott Server BWI Airport 5.65
10/4/2007 Lupinek Server BWI Airport 7.15
10/4/2007 Clark Server BWI Airport 9.14
10/5/2007 Fantinato Server BWI Airport 9.26
10/5/2007 Clark Server BWI Airport 7.27
10/5/2007 Altmire Server BWI Airport 8.77
10/5/2007 Jacobs Server BWI Airport 8.78
10/5/2007 Lupinek Server BWI Airport 6.91
10/5/2007 Eifert Server BWI Airport 8.73
10/5/2007 Zimmerman Server BWI Airport 9.2
10/5/2007 Mcelroy Server BWI Airport 6.74
10/6/2007 Goodman Server BWI Airport 6.45
10/6/2007 Eifert Server BWI Airport 6.35
10/6/2007 Good Server BWI Airport 8.91
10/6/2007 Bryant Server BWI Airport 8.59
10/6/2007 Clark Server BWI Airport 7.2
10/6/2007 Lupinek Server BWI Airport 12.4
10/7/2007 Goodman Server BWI Airport 8.82
10/7/2007 Zimmerman Server BWI Airport 9.43
10/7/2007 Lupinek Server BWI Airport 13.12
10/7/2007 Good Server BWI Airport 5.96
10/7/2007 Bryant Server BWI Airport 15.7
10/8/2007 Carter Server BWI Airport 9.99
10/8/2007 Nathaniel Server BWI Airport 8.58
10/8/2007 Zimmerman Server BWI Airport 12.74
10/8/2007 Lupinek Server BWI Airport 7.77
10/8/2007 Jacobs Server BWI Airport 6.94
10/8/2007 Elliott Server BWI Airport 6.61
10/8/2007 Laribee Server BWI Airport 8.15
10/8/2007 Fantinato Server BWI Airport 3.34
10/9/2007 Fantinato Server BWI Airport 6.85
10/9/2007 Jacobs Server BWI Airport 8.57
10/9/2007 Eifert Server BWI Airport 8.57
10/9/2007 Lupinek Server BWI Airport 8.54
10/9/2007 Elliott Server BWI Airport 7.95
10/9/2007 Altmire Server BWI Airport 7.77
10/9/2007 Carter Server BWI Airport 6.4
10/9/2007 Nathaniel Server BWI Airport 7.13
10/10/2007 Fantinato Server BWI Airport 6.75
10/10/2007 Lupinek Server BWI Airport 6.54
10/10/2007 Carter Server BWI Airport 9.18
10/10/2007 Elliott Server BWI Airport 8.85
10/10/2007 Clark Server BWI Airport 8.61
10/10/2007 Jacobs Server BWI Airport 8.85
10/10/2007 Zimmerman Server BWI Airport 6.19
10/10/2007 Eifert Server BWI Airport 8.82
10/5/2007 Nathaniel Server Train BWI Airport 5.01
10/6/2007 Nathaniel Server Train BWI Airport 7.68
10/7/2007 Nathaniel Server Train BWI Airport 8.79
10/1/2007 Custis Bar Easton MD 6.44
10/1/2007 Cherry Bar Easton MD 8.7
10/1/2007 Gale Bar Easton MD 2.28
10/2/2007 Cherry Bar Easton MD 3.97
10/2/2007 Custis Bar Easton MD 6.57
10/2/2007 Gale Bar Easton MD 9.44
10/3/2007 Hunter Bar Easton MD 8.12
10/3/2007 Cherry Bar Easton MD 10.71
10/3/2007 Gale Bar Easton MD 10.24
10/4/2007 Custis Bar Easton MD 15.8
10/4/2007 Ruff Bar Easton MD 4.6
10/5/2007 Hunter Bar Easton MD 8.11
10/5/2007 Custis Bar Easton MD 10.09
10/5/2007 Gale Bar Easton MD 6.13
10/5/2007 Cherry Bar Easton MD 10.18
10/5/2007 Ruff Bar Easton MD 9.16
10/6/2007 Custis Bar Easton MD 5.04
10/6/2007 Hunter Bar Easton MD 8.26
10/6/2007 Ruff Bar Easton MD 8.85
10/6/2007 Gale Bar Easton MD 11.01
10/7/2007 Ruff Bar Easton MD 4.68
10/7/2007 Custis Bar Easton MD 6.2
10/7/2007 Gale Bar Easton MD 4.47
10/7/2007 Cherry Bar Easton MD 9.26
10/8/2007 Custis Bar Easton MD 6.76
10/8/2007 Ruff Bar Easton MD 2.71
10/8/2007 Gale Bar Easton MD 8.93
10/9/2007 Custis Bar Easton MD 6.62
10/9/2007 Gale Bar Easton MD 3.93
10/9/2007 Cherry Bar Easton MD 9.29
10/10/2007 Cherry Bar Easton MD 3.78
10/10/2007 Roberts Bar Easton MD 8.37
10/10/2007 Gale Bar Easton MD 14.99
10/10/2007 Hunter Bar Easton MD 9.08
10/3/2007 Roberts Bar/Server/6 Easton MD 8.35
10/4/2007 Roberts Bar/Server/6 Easton MD 9.07
10/5/2007 Roberts Bar/Server/6 Easton MD 9.21
10/6/2007 Laneve Bar/Server/6 Easton MD 9.27
10/10/2007 Roberts Bar/Server/6 Easton MD 0.47
10/10/2007 Weber Bar/Server/6 Easton MD 10.31
10/1/2007 Jones Cook Easton MD 2.97
10/1/2007 Taylor Cook Easton MD 6.36
10/1/2007 Armstrong Cook Easton MD 4.23
10/1/2007 Taylor Cook Easton MD 6.48
10/2/2007 Foster Cook Easton MD 8.64
10/2/2007 Taylor Cook Easton MD 6.16
10/2/2007 Ames Jr Cook Easton MD 5.04
10/2/2007 Jones Cook Easton MD 4.94
10/3/2007 Foster Cook Easton MD 4.67
10/3/2007 Ames Jr Cook Easton MD 6.77
10/3/2007 Taylor Cook Easton MD 6.33
10/3/2007 Armstrong Cook Easton MD 4.17
10/4/2007 Ames Jr Cook Easton MD 2.95
10/4/2007 Jones Cook Easton MD 4.26
10/4/2007 Armstrong Cook Easton MD 3.94
10/4/2007 Foster Cook Easton MD 6.87
10/4/2007 Taylor Cook Easton MD 5.17
10/5/2007 Taylor Cook Easton MD 7.44
10/5/2007 Armstrong Cook Easton MD 5.27
10/5/2007 Taylor Cook Easton MD 5.25
10/5/2007 Foster Cook Easton MD 6.43
10/5/2007 Jones Cook Easton MD 7.96
10/6/2007 Conley Cook Easton MD 6.29
10/6/2007 Foster Cook Easton MD 5.38
10/6/2007 Taylor Cook Easton MD 5.65
10/6/2007 Taylor Cook Easton MD 6.03
10/6/2007 Jones Cook Easton MD 4.46
10/7/2007 Armstrong Cook Easton MD 8.35
10/7/2007 Taylor Cook Easton MD 6.07
10/7/2007 Conley Cook Easton MD 10.08
10/8/2007 Armstrong Cook Easton MD 3.73
10/8/2007 Ames Jr Cook Easton MD 5.28
10/8/2007 Taylor Cook Easton MD 6.02
10/8/2007 Taylor Cook Easton MD 5.15
10/9/2007 Ames Jr Cook Easton MD 4.02
10/9/2007 Armstrong Cook Easton MD 5.09
10/9/2007 Foster Cook Easton MD 10.25
10/9/2007 Taylor Cook Easton MD 8.17
10/10/2007 Foster Cook Easton MD 4.49
10/10/2007 Taylor Cook Easton MD 6.65
10/10/2007 Ames Jr Cook Easton MD 6.21
10/10/2007 Jones Cook Easton MD 4.32
10/10/2007 Armstrong Cook Easton MD 4.24
10/1/2007 Harris Dish Easton MD 4.64
10/1/2007 Shahan Dish Easton MD 4.35
10/2/2007 Shahan Dish Easton MD 4.43
10/3/2007 Shahan Dish Easton MD 4.55
10/3/2007 Greene Dish Easton MD 4.24
10/4/2007 Shahan Dish Easton MD 4.64
10/4/2007 Harris Dish Easton MD 4.26
10/5/2007 Harris Dish Easton MD 5.25
10/5/2007 Shahan Dish Easton MD 5.43
10/6/2007 Greene Dish Easton MD 9.13
10/7/2007 Greene Dish Easton MD 4.17
10/7/2007 Harris Dish Easton MD 4.94
10/8/2007 Harris Dish Easton MD 4.15
10/8/2007 Shahan Dish Easton MD 6.19
10/9/2007 Greene Dish Easton MD 5.32
10/9/2007 Shahan Dish Easton MD 3.69
10/10/2007 Harris Dish Easton MD 4.96
10/10/2007 Shahan Dish Easton MD 3.05
10/1/2007 Yates Host/Hostess Easton MD 9.4
10/2/2007 Johnson Host/Hostess Easton MD 3.48
10/3/2007 Yates Host/Hostess Easton MD 4.07
10/3/2007 Wilson Host/Hostess Easton MD 4.29
10/4/2007 Yates Host/Hostess Easton MD 4.03
10/4/2007 Wilson Host/Hostess Easton MD 4.29
10/5/2007 Ross Host/Hostess Easton MD 3.39
10/5/2007 Yates Host/Hostess Easton MD 4.19
10/5/2007 Johnson Host/Hostess Easton MD 4.06
10/6/2007 Ross Host/Hostess Easton MD 4.92
10/6/2007 Jones Host/Hostess Easton MD 6
10/7/2007 Ross Host/Hostess Easton MD 3.23
10/7/2007 Johnson Host/Hostess Easton MD 6.48
10/8/2007 Ross Host/Hostess Easton MD 2.94
10/8/2007 Yates Host/Hostess Easton MD 3.98
10/9/2007 Johnson Host/Hostess Easton MD 4.36
10/9/2007 Yates Host/Hostess Easton MD 4.44
10/10/2007 Ross Host/Hostess Easton MD 4.1
10/10/2007 Yates Host/Hostess Easton MD 3.96
10/1/2007 Sedgwick Salary Mgr Easton MD 11.7
10/1/2007 Lewis Salary Mgr Easton MD 8.54
10/2/2007 Kreger Salary Mgr Easton MD 3.86
10/2/2007 Friend Salary Mgr Easton MD 9.67
10/2/2007 Lewis Salary Mgr Easton MD 8.38
10/3/2007 Sedgwick Salary Mgr Easton MD 9.25
10/3/2007 Friend Salary Mgr Easton MD 9.67
10/4/2007 Sedgwick Salary Mgr Easton MD 9.37
10/4/2007 Friend Salary Mgr Easton MD 8.26
10/5/2007 Sedgwick Salary Mgr Easton MD 9.68
10/5/2007 Lewis Salary Mgr Easton MD 9.57
10/6/2007 Lewis Salary Mgr Easton MD 9.92
10/6/2007 Friend Salary Mgr Easton MD 9
10/7/2007 Friend Salary Mgr Easton MD 8.18
10/7/2007 Sedgwick Salary Mgr Easton MD 8.37
10/7/2007 Lewis Salary Mgr Easton MD 8.75
10/8/2007 Lewis Salary Mgr Easton MD 8.6
10/8/2007 Friend Salary Mgr Easton MD 8.6
10/8/2007 Sedgwick Salary Mgr Easton MD 8.37
10/9/2007 Sedgwick Salary Mgr Easton MD 8.65
10/9/2007 Friend Salary Mgr Easton MD 10.51
10/10/2007 Kass Salary Mgr Easton MD 6.19
10/10/2007 Lewis Salary Mgr Easton MD 9.81
10/10/2007 Sedgwick Salary Mgr Easton MD 9.21
10/1/2007 Conrad Security Easton MD 4.6
10/3/2007 Downes Security Easton MD 4.44
10/3/2007 Ennals Security Easton MD 5.36
10/3/2007 Argueta Security Easton MD 4.4
10/4/2007 Ennals Security Easton MD 3.87
10/5/2007 Conrad Security Easton MD 5.42
10/5/2007 Downes Security Easton MD 4.4
10/5/2007 Ennals Security Easton MD 4.8
10/5/2007 Pinder Jr Security Easton MD 4
10/5/2007 Argueta Security Easton MD 5.22
10/6/2007 Downes Security Easton MD 4.4
10/6/2007 Argueta Security Easton MD 5.32
10/6/2007 Pinder Jr Security Easton MD 5.05
10/6/2007 Conrad Security Easton MD 4.72
10/7/2007 Conrad Security Easton MD 6.76
10/8/2007 Conrad Security Easton MD 5.19
10/10/2007 Downes Security Easton MD 4.7
10/10/2007 Ennals Security Easton MD 5.99
10/10/2007 Conrad Security Easton MD 5.17
10/1/2007 Travers Server Easton MD 4.53
10/1/2007 Coleman Server Easton MD 6.58
10/1/2007 Weber Server Easton MD 3.79
10/1/2007 Leene Server Easton MD 2.47
10/2/2007 Machlinski Server Easton MD 4.75
10/2/2007 Edwards Server Easton MD 4.52
10/2/2007 Leene Server Easton MD 4.04
10/2/2007 Kearney Server Easton MD 3.91
10/2/2007 Weber Server Easton MD 3.43
10/2/2007 Sinclair Server Easton MD 6.47
10/3/2007 Weber Server Easton MD 8.44
10/3/2007 Travers Server Easton MD 4.78
10/3/2007 Sinclair Server Easton MD 4.59
10/3/2007 Wilczenski Server Easton MD 4.38
10/3/2007 Machlinski Server Easton MD 4.08
10/4/2007 Weber Server Easton MD 4.93
10/4/2007 Leene Server Easton MD 4.66
10/4/2007 Outten Server Easton MD 4.44
10/4/2007 Sinclair Server Easton MD 5.61
10/4/2007 Coleman Server Easton MD 4.5
10/5/2007 Outten Server Easton MD 4.65
10/5/2007 Weber Server Easton MD 11.09
10/5/2007 Coleman Server Easton MD 7.89
10/5/2007 Wilczenski Server Easton MD 7.81
10/5/2007 Sinclair Server Easton MD 6.38
10/6/2007 Travers Server Easton MD 6.81
10/6/2007 Toomalatai Server Easton MD 4.62
10/6/2007 Sinclair Server Easton MD 5.21
10/6/2007 Wilczenski Server Easton MD 6.14
10/6/2007 Outten Server Easton MD 4.42
10/6/2007 Machlinski Server Easton MD 5.37
10/6/2007 Leene Server Easton MD 5.34
10/6/2007 Coleman Server Easton MD 4.96

 

[PHV]

Have you tried to follow the Crosstab query wizard ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[collinjones]

Yes but it has problems, or I am missing somthing to report month to date totals, week to date totals, and yesterday's totals on the same report using the same data table so i can have one dump of information per day.

I need to find a way to have excel or access subtotal hours for the three above mentioned values for each job code at every location.

I am also seeing if a pivot table will work but that will require at least three data dumps, four when i will try to get values of net sales per hour for each row.

 

[dhookom]

You can create 3 separate crosstabs and either use them a subreports or union them together into a single query.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]