ProRate Salary Formula Help

[AS2006]

Hi,

I am trying to create a query that calculates Bonus Prorate and Salary Prorate. In my query I had the following fields: Employee Id, Name, start date, Salary, Bonus, Disc Bonus, Guaranteed Bonus, Total Bonus.

The formula I was told to use to get the Salary prorated value is:

start date/365 x salary. How can I incorporate this in Access query?

Thanks a lot!

 

[Malcy]

Hi
I think someone has not given you quite the right formula since it does not make sense. If my start date was 01/01/2006 and my salary was £10,000 then according to your formula the prorated value would be
01/01/06 / 365 * 10000
Which patently is cobblers
It may be you need to calculate the number of days employment so it becomes
DateDiff(#01/01/06#, #18/06/06#) / 365 * 10000
which works out at something like £5,000
Does that make sense?

If so, then you need to find the number of days using DateDiff but using [StartDate] and Date() to get the number of days (call it WorkDays) and then use ([WorkDays]/365)*[Salary]

Hope this helps a bit
Good luck

 

[AS2006]

Thanks thats works!

 

[Malcy]

Cool
Good luck with the rest of it