Payroll Datasheet

[Guest]

I would like to duplicate the current excel spreadsheet for payroll in
Access. The goal is to mimic the behavior of the excel spreadsheet, which is
organized by weekly hours, so that the users in payroll will actually adopt
it. I've got two tables. One for Employees the other for Employee Hours
that are combined in a form in datasheet view. I can filter the records by
Beginning Date to give me the desired data, no problem. But how can I enter
the hours for a new week without having to repopulate the entire roster of
employees? When I'm adding the hours for a new week, I have to specify which
employee gets those hours, la-de-da... Is there a way to get Access to
present me with a complete (and updated) list of the employees for the new
week?

 

[Amy Blankenship]

Use a query with a left or right join to the employees table as the record
source.

HTH;

Amy

 

[Guest]

Hi Amy,

Thanks for your response... I've gotten the tables to merge together in an
acceptable way by using a form and a subform in datasheet view, however, the
problems is when I'm populating data for the new week, I must repopulate the
entire roster for those new hours. If I miss one, whoops, somebody doesn't
get paid. What I need is for the entire roster to appear at once, with the
hours to be filled in for the new week. It's something like this...

Employee Wk Mon Tue Wed Thu Fri Sat Sun Ttl Reg OT
PTO

emp1 2 8 8 8 8 8 0 0
40 40 0 0
emp2 2 0 6 7 5 9 4 0
21 21 0 0
emp3 2 10 5 0 0 0 11 10
36 36 0 0
.... ............

From Employee From Employee Hours
Calculated
Table Table
Fields

Let's say these are hours from one week (Wk2) ... Next week, at Wk3 I've
got to repopulate the employee fields for that week, instead of simply
filling in the hours for the employee roster that already exists. I don't
know of a way in which joining tables in a query will produce that. Am I
wrong?

Jaybird

 

[Guest]

Well, of course, the formatting is off on the above... Don't know why I
bothered doing it that way. Hopefully, you get the idea.

 

[Amy Blankenship]

If you use a join (left or right) as the data source, it will pull all
records from one side of the join regardless of whether any records exist on
the other side of the join. If you're still having trouble, you could
probably post asking people interested in paid consulting to e.mail you
privately.

HTH;

Amy

 

[Guest]

Thanks for your help, Amy. I thought I had created this relationship
correctly the first time... I reviewed my work and found that you were
right. That fixed the problem. Thanks again!

Jaybird