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

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

Date: Sat, 19 Mar 2005 09:33:02 -0800

Thanks for the help. It did not work. Rate is a dollar amount and the admin
costs is a percentage of that dollar amount.

"Marshall Barton" wrote:

> 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.
>
>
> 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)
>
> --
> Marsh
> MVP [MS Access]
>

Relevant Pages

  • Re: Using 0days as part of pen-test?
    ... decides to hack the system" as part of a security review. ... ongoing costs for defending against it tend to be uneconomic. ... by posting an armed soldier behind the admin, ... guard when this happens (as the guard isn't even allowed to look at the ...
    (Pen-Test)
  • Re: Vulnerability scanners
    ... firewall using SSL to hit Qualys's web/scanner server. ... It breaks it down into reports for techies and reports for non-techies ... >> to include some equipment costs in there. ... And if you already didn't have an admin, ...
    (Pen-Test)
  • Re: expression i need to write rate -admin costs*driver percentage
    ... still leaves out the admin costs. ... >>currency, driver percentage is number, intger,and currency. ...
    (microsoft.public.access.queries)
  • Re: Vulnerability scanners
    ... > to include some equipment costs in there. ... And if you already didn't have an admin, ... If, however, you have a developer automate ... incremental cost. ...
    (Pen-Test)
  • Re: HELP!need to determine price based on time to complete using Min. Hour. And days
    ... sorry for confusing you ... costs for the days: ... Just replace my dummy 'rate variables' with ... For the cost to produce,> We do not have a RATE we have a Dollar Amount. ...
    (microsoft.public.excel.worksheet.functions)