Recent content by krichard

Hi Guys... i really appreciate everyone's help on this... the function above... =Sum(Val(TimeSheetQuery!EmployeeHours)) just returns 0's I have this formula below working on a form, with a subform, for when I am entering the employees hours... =[TimeSheet Subform].Form!SummedHoursMinutes...

Option Compare Database Option Explicit Public Function HoursAndMinutes(interval As Variant) As String '*********************************************************************** ' Function HoursAndMinutes(interval As Variant) As String ' Returns time interval formatted as a hours:minutes string...

Hi Paul.. I have my employeeId in the group header, and I created a group footer, and i entered this calculation to total my hours for that person =Sum(TimeSheetQuery!EmployeeHours) and i get the following error: datatype mismatch in criteria expression thanks for your help..

It does come out as a number... actually a time... i have 8:00 for the amount of hours/minutes past... left aligned. now i just want to add the hours up for each employeeid..

SELECT EmployeeId, Sum(EmployeeHours) FROM TimeSheetQuery GROUP BY EmployeeId I tried that and i am still getting the Error: Datatype mismatch in criteria...

SELECT EmployeeId, Sum(HoursAndMinutes) As EXPR1 FROM TimeSheetQuery GROUP BY EmployeeId Error: Datatype mismatch in criteria... This is the calculation in my TimeSheetQuery Expr1: HoursandMinutes([TimeOut]-[TimeIn]) I want to add up the total hours worked for each employeeID #... So I made...

hmmm.. can you explain to me how i would go about doing that? Thank you!

Hello.. Hopefully this is my last question... I would like to sum the total hours worked for each employee in a report... right now my report is displaying the total hours for each day, so I have Eric listed 5 times because he worked 5 days, and his hours for each day are listed next to his...

IT WORKED! THANK YOU ... :-)

Hi... I would like to print out a report, where it is sorted by the employee name.. I have a First Name Header, and then I have all the details for that employee under details... when it prints out, sometimes it will list the employee name at the end of the page, and then list all of their...

That worked!!! Thank you! I do have one other question... i will post as new question... thanks again!

Its "employees" from my employees table.

Hi... I have a Timesheet form, that has a subform in it... The main form just has an employee ID, and Name at the top... when i click to the next record, it goes in order of employeeID, but I want it to go in order of Employee Name... there is no order by in the properties for my code...

Thank you for your help! :-)

Ok... nevermind, i found a new piece of code that does mostly what i want... onmouseover="document.getElementById('changeThisBG').style.backgroundImage='URL(images/links/BerkshireEast.gif)';> I can get the above code to work, but when i add the following code... background-repeat: no-repeat...