Re: expression i need to write rate -admin costs*driver percentage

From: dasad (dasad_at_discussions.microsoft.com)
Date: 03/21/05 

Date: Mon, 21 Mar 2005 05:13:06 -0800

Driver Pay: [rate]*[driver percentage]/100
this is the expression I am currently using. I need to add in the admin
costs. I have "cut and paste" all the formulas you both have given me and it
still leaves out the admin costs. Instead of 23.75, I get 25.00.

I really appreciate the help on this.

"Marshall Barton" wrote:

> How about that, my original guess was the right one ;-)
>
> Now let's go back and try the expression I posted earlier
> and see if we can figure out what about it, or your data,
> leads you to think "it doesn't work".
>
> Do you have a data record with a Rate of 100, Admin of 5 and
> Dirver 25? Try it and see what result you get, it should be
> 23.75. If not, pleas post back with the result you did get
> along with a Copy/Paste of the **exact** expression you're
> using.
>
> Check Andreas posts too. We are both suggesting equivalent
> expressions that will produce the same results. He also
> makes a good point about using names with spaces or other
> funky characters.
> --
> Marsh
> MVP [MS Access]
>
>
>
> dasad wrote:
> >i work at a truck line. i have a table for every load we book with the rate
> >for the load. From this table i have a query to pay the drivers for each
> >load (rate * driver percentage/100) In the design of the table rate is
> >currency, driver percentage is number, intger,and currency. Admin costs is
> >listed the same as the driver percentage. right now I have a report pulled
> >from the query to do a "payroll" *** per driver. I need to deduct an
> >optional 5% admin costs from the rate prior to the driver percentage.
> >example: rate is $100.00 minus $5.00 for admin cost, the driver gets paid a
> >percentage of the $95.00 that is left.
> >
> >>
> >> dasad wrote:
> >> >Thanks for the help. It did not work. Rate is a dollar amount and the admin
> >> >costs is a percentage of that dollar amount.
> >> >
> >> >
> >> >> dasad wrote:
> >> >> >I have three fields in a table rate, admin costs and driver percentage
> >> >> >
> >> >> >1. Rate - currency
> >> >> >2. Admin Costs - number intger currency default 5
> >> >> >3. driver percentage - number intger currency default 25
> >> >> >
> >> >> >I need an expression to have rate - admin costs * driver percentage.
> >> >> >Right now I have rate * driver percentage but I can not get it to deduct the
> >> >> >5% in admin costs. I need the driver percentage based on the rate minus
> >> >> >admin costs.
> >> >>
> >> >>
> >> >"Marshall Barton" wrote:
> >> >> Not sure what you're trying to do here. Is Admin Costs a
> >> >> percent? Is Rate a dollar amount?
> >> >>
> >> >> Maybe this is close??
> >> >> Rate* (1 - [Admin Costs]/100) * ([driver percentage]/100)
>