[mso] Re: access design question

 
 
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
*************************************************************

Other related posts: