View revords by date

[registan]

I have three tables, I put pictures below. Now, I want to create a query that shows me wether employee worked that particular day or not, and what was his/her salary at that day? Is it possible? Please help. I need it very much. My "enter" key doesn't working properly, sorry for that.

[June7]

Images in post are not displaying.

[registan]

OK, I have two employees, John and Jack, on 1st January John's salary was $100 per hour, Jack's was $120 per hour, on 2nd Jamuary, John has $150 per hour, Jack has $200. Now, in their timetables I want to see salaries by day, if their salary was $100, it should give me $100, if $150, $150. Now, it's showing me smth like this: 01.01.2012 John $100, 01.01.2012 John $120, 02.01.2012 John $100, 02.01.2012 John $120 etc. Hope you got me

[pbaldy]

The images are working fine for me, there's just a little lag time in them filling in.

[June7]

Oh, those images are on a fileshare site and I am being blocked. Will have to look at when I get home. Not really understanding the issue. Even after viewing the images will probably have to work with data to figure it out.

Personally, think I would do payroll with an off-the-shelf like Quickbooks.