Search results for query: *

DUH....geez i feel smart I knew that, i was figuring there was some more complicated term

Ok so the Pivot Table is working good, giving me the data I need and the grouping seems to be working fine. Now..I have a certain format i need to present this dats. I am working through linking the spreadsheet and am thinking that the only link that will cause me problems is the links for...

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...

how would I get the month to date, week to date, and yesterday's hours totals?

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...

I have a large file I will need to update daily with daily records of hours worked. Each row contains Job Code, Locaiton as well as date and hours worked. I need a formula or set of formulas to give me three values for a certain group of information. For example I have all this information, it...

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...

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?

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...