>
> Hi I have a problem forming a query
> I have 3 tables salary(hrs, clock_in , clock_out)
> Break ( date, employe_id, net_time, break_in, break_out)
> Employee(employee_id, pay_rate, name)
>
> I need to get an hourly report till the current time for that day
> stating name, hour, no of hours, salary
> Example
>
> Rob 3-4 48min $6.56
> Min 2-3 23min $2.34
> Min 3-4 54min $7.67
>
> And so on..Would appreciate help on this.since I cant come up with the
> query
>
How do you intend to find out which entry in your table "salary" is
related
to which employee as there is no id to refer to.
Am I right in assuming your column "hour" with entries 3-4, 2-3, ...
means from 3 til 4 o'clock and so on?
Regards, Christoph