Combining Records

[Dineedshelp]

HELP!!!

I have a set of employee records that have been paid in different payroll weeks (bog standard parameter that asks which payroll weeks you want to look at). Some of these records are for the same employee but for different payroll weeks. The payroll weeks are based on a Monday to Sunday working week. Due to some timesheets coming in late, employees might not be paid all their shifts in the correct week, but be paid for them the week after that. I need to find a way of identifying these late shifts, working out what week they should have been paid in and if they were paid any other shifts that week.


We have fields such as name, payroll number, shift date, payroll week number, amount paid for each shift, hours worked for each shift.

Please help, its Bank holiday weekend and I don't want to spend it in work!!!

Di

 

[randysmid]

Hi,
I would like to recommend that you add a field indicating whether the person was paid for that shift date record. The query that picks out the shift records that need to be paid will search the current week, PLUS any shift records that were NOT paid from prior weeks. Obviously, once the employee has been paid for any given record, the flag needs to be turned off. This field might be called "Paid" with a boolean value initially set to "False". Once the employee has been "paid", the value needs to be switched to "True". You could add an additional field called "PaidDate" so that everyone will know when a particular shift date record was physically paid.

HTH,
Randy Smith
California Teachers Association

 

[Dineedshelp]

That would be a way to do it, unfortunatly the database we are working with was not created by us and therefore is locked. There is nothing more we can add, we can only use the infor from it.

 

[randysmid]

Hi,
What kind of database is it? In some instances, code can be written to add a new field without having direct access to the table. I wrote an FAQ on how to create a new database (actually the tip is from Microsoft), but inside of this tip is the code necessary to add a new field. Here is the FAQ: faq705-2714

HTH,
Randy Smith
California Teachers Association