weekly employee hours report by days

[axle124]

weekly employee hours report by days please help!!!!!!!!!!!

First I have not programmed in access for a long time, so please forgive me for my rather simple problem. I have to give my boss a daily hours report for the week. Ie:

Employee name dept mon tues wed thurs fri sat sun total
john doe eng 8 8 8 8 8 0 0 40


I have went at this several ways and just can not get the right answer. I can get the totals for each day but the query i have does them as individual records ie:

Employee name dept mon tues wed thurs fri sat sun total
john doe eng 8 0 0 0 0 0 0 8
john doe eng 0 8 0 0 0 0 0 8

I would appreciate any help on this matter.
SELECT [needing new idea3].clock, [needing new idea3].Lastname, employee.Departmentid, [needing new idea3].day1, [needing new idea3].day2, [needing new idea3].day3, [needing new idea3].day4, [needing new idea3].day5, [needing new idea3].day6, [needing new idea3].d1, [needing new idea3].d2, [needing new idea3].d3, [needing new idea3].d4, [needing new idea3].d5, [needing new idea3].d6
FROM employee INNER JOIN [needing new idea3] ON employee.clock=[needing new idea3].clock
WHERE newtot>0;


Brandon

 

[axle124]

I have thought about doing this with a loop or even by grouping, but I just cant seem to get the format right. I would apprecaite any suggestions that would be applicable.

I have a table that clocks in and out an employee. I then query to figure the total for that day. I want to be able to total a week and show the daily hours also. I know this can be done, but I am used to visual basic and would simply use an array with an if stmnt to accomplish this. I am not as familiar with access. So any help will be appreciated.

 

[raskew]

Hi -

I have a table that clocks in and out an employee.

What table is that?

What is [needing new idea3]? And what are the [clock] fields in the two tables cited?

It kind of sounds as if you are storing the elapsed time (a calculation) rather than just querying for it as needed.

Please elaborate.

Bob

 

[axle124]

I have two tables: employee and timecard.
employee
clock(basically employee number we call it clock number)
name
deptno
deptname

time card
clock based on employee
clockin
clockout

I then have a query(needing new idea) in which i get the total hours worked by the employee. I need to be able find one week at a time of just daily hours. Ie if I enter a week ending date of 3/9/09 then my query will then show me the daily hours worked by that employee for the 7 days(including that day) by department. I do have a query in which i able to find the information i need but cannot seem to make it an individual record. I am stumped. I know I am going at this wrong, but i cant figure a fresh approach to try. I appreciate any help on this matter.

Brandon

 

[gemma-the-husky]

time card
clock based on employee
clockin
clockout

this may prove a problem if an employee clocks in/out at breaks/lunchtime, so you have more than one work session per day - but otherwise it seems OK

can you expand on where you are stuck because you seem to have the data organised properly

you probably just need to work with a "totals" query - open your query in design mode, then click the sigma icon -(the same as autosum in Excel )

 

[axle124]

Yes i can get totals, but the way i need it formatted is a daily hours under the correct date and then the total for that week.

ie: clock 3/1/09 3/2/09 3/3/09 3/4/09 3/5/09 3/6/09 3/7/09 weektot
**1111** 8**** 8**** 8**** 8**** 8**** 0*****0**** 40
**1112** 8**** 0**** 8**** 8**** 8**** 0*****8**** 40

but of course daily total will be under the correct date.
So basically pull the data that I already have and put it on one line in a report, so the owner can keep up with who is working what.

brandon

 

[raskew]

Is it possible to post your zipped database with some sample data?

Bob

 

[axle124]

I have a lot of trial queries on here so it may be a little jumbled
The needing new idea queries are the ones in which I am working with at this moment
brandon