[mso] Re: FW: access design question- repost

Under normal circumstances, it is not good practice to put the result of a 
calculation back into a table.  The calculation can always be performed 
again at a later date.

However, this is probably one of those times when you do want to put it back 
into the table.  The reason for this is that the holiday hours - once 
calculated - will be added to the person's "account", and would remain 
unchanged even if the calculation percentage were to change in the future.

If you have existing records without the holiday allowance in them, you'll 
need to back-fill these.  Then, whatever you are using to create new records 
will simply calculate holidays and insert them at the same time.

However, there are sure to be other things that need to be calculated as 
well - sick leave, long-service leave, etc - as well as mechanisms to allow 
the employee to use these allocations, plus possible others, such as 
compassionate leave.

Payroll systems are specialist software packages, which produce output that 
affects employees directly, and also need to produce official documents for 
taxation statement, annual earnings, etc.  They need specialist design and 
programming (or the simple purchase of a commercial package) to ensure that 
they comply with all the legal requirements of the various Government 
agencies.  If the output of this system will affect employees in any way, 
then do not approach it in an ad hoc fashion.

Regards, Dave S

----- Original Message ----- 
From: "Fitzmaurice, Ann E." <a.e.fitzmaurice@xxxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Sent: Friday, January 04, 2008 10:33 AM
Subject: [mso] FW: access design question- repost


>
>
> Ann E Fitzmaurice
>
> ________________________________
>
> ________________________________
>
> From: Ann E Fitzmaurice [mailto:a.e.fitzmaurice@xxxxxxxxxx]
> Sent: Wed 26/12/2007 20:53
> To: mso-bounce@xxxxxxxxxxxxx
> Cc: Fitzmaurice, Ann E.
> Subject: access design question
>
>
>
> Hi have a data base of , name of person, date worked , hours worked and 
> amount per hour,
>
>
>
> Have set up a report that produces a separate report for each person, the 
> date worked , the amojt earned and the over all total
>
>
>
> I now have to add a percentage allowandce for holoday, which for 
> simplicity will say is 10% of the hours worked
>
>
>
> An anyone suggest the best way to obtain this information, should I 
> include in the table as a calculation and if so how, create a separate 
> table with the percentage in and then generate a query / report giving the 
> total hours worked ina given period and the total holiday entitlement in 
> that period.  There is one additional complication, the holiday can be 
> accrued over more than one time period , and therefore I need to be able 
> to generate the holiday entitlement to date , less any holiday that might 
> be taken, am unsure also how to incorporate this last piece into the 
> jigsaw, hence the subject access design question.
>
>
>
> Any ideas
>
>
>
> Regards
>
>
>
> Ann
>
>
>
>
>
> Ann E Fitzmaurice
>
> Medical Statistician
>
> Immpact University of Aberdeen
>
> Health Sciences Building
>
> Foresterhill
>
> Aberdeen, AB25 2ZD
>
> Scotland
>
> Tel: +44 (0)1224 553876
>
> Fax: +44 (0)1224 555704
>
> Email: a.e.fitzmaurice@xxxxxxxxxx <mailto:a.e.fitzmaurice@xxxxxxxxxx>
>
>
>
>
> *************************************************************
> You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
> MicrosoftOffice@xxxxxxxxxxxxxxxx
>
> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
> To Unsubscribe from this group, visit the group's homepage and use the 
> dropdown menu at the top.  This will allow you to unsubscribe your email 
> address or change your email settings to digest or vacation (no mail).
> http://www.freelists.org/webpage/mso
>
> To be able to share files with the group, you must join our Yahoo sister 
> group.  This group will not allow for posting of emails, but will allow 
> you to join and share problem files, templates, etc.: 
> http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for 
> FILE SHARING ONLY.
>
> If you are using Outlook and you see a lot of unnecessary code in your 
> email messages, read these instructions that explain why and how to fix 
> it:
> http://personal-computer-tutor.com/abc3/v28/greg28.htm
> ************************************************************* 

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister group. 
 This group will not allow for posting of emails, but will allow you to join 
and share problem files, templates, etc.:  
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE 
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: