Novice
Windows 7 32bit 
Access 2007
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.
VIP
Windows XP Access 2010 32bit
Images in post are not displaying.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Novice
Windows 7 32bit Access 2007
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
Who is John Galt?
Windows XP Access 2007
The images are working fine for me, there's just a little lag time in them filling in.
VIP
Windows XP Access 2010 32bit
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.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Connect Two Charts to Start & End date, and pull up Field Values from End date?
Posting Permissions
Reply With Quote