I would like to add another criteria for the records.  I would like for it to return all of the records based on the following criteria and add another criteria.  I would like for it to return the records between the following input dates.  input.Week_Start_Date and input.Week_Through_Date

basically I want to see how many hours an employee has worked for a particular client during a time period I select.

this is what I have......

rec = Employee_Time[Name == input.Employee_Name && Company_Name == input.Company_Name];

Regular_Hours=rec.sum(Regular_Hours);

Overtime_Hours=rec.sum(Overtime_Hours);

if(input.Regular_Hours  =  null)

{

Regular_Hours=0.0;

}

if(input.Overtime_Hours  =  null)

{

Overtime_Hours=0.0;

}

Total_Hours=(input.Regular_Hours  +  input.Overtime_Hours);