I have (3) tables:
Utility (table for generic reports layout)
Employees (ID, Name)
TimeClockEntries (ID, ClockIn, ClockOut, Calc_TotalTime)
I have a layout based on the utility table, with two filters (globals): StartDate, End Date. I want to display a portal of Employees who had a time clock entry between the two filter dates AND a total number of hours (i.e. sum of the time clock entries).
I can get the first part (Employees who had time clock entries between the dates), but I cannot for the life of me figure out how to do the calculation of Sum(Calc_TotalTime). Every direction I have taken only shows a sum of ALL that employee's time clock entries, and not just the ones within the filtered dates.
Please let me know if this is something you can help with.
In other DBMS's I would have written a SQL string with a few where conditions and would be done with it.
Thanks in advance.