Calculating Percentage

[imright]

This one should be easy for all you brainiacs out there but it perplexes me.
I have a query where I'm calculating two separate percentage by building an expression then I have to combine them to create a total percentage by taking 40% of one and 60% of the other.
This works fine but seems there must be an easier way than building three different expressions. The real problem is when I go from design view to data view it asks for the parameter of each expression which is now up to 4. Its more of an annoyance to me but I will need to let others in the company use this.

 

[boblarson]

How about posting the expressions you are trying to use currently?

 

[Michael J Ross]

How about this?, all in a single expression, shouldn't ask for parameters as long as you are using fields from a table or another query in the query.

Total%: 0.4*([Field1]/[Field2])+(0.6*([Field3]/[field4]))

 

[boblarson]

How about this?, all in a single expression, shouldn't ask for parameters as long as you are using fields from a table or another query in the query.

Total%: 0.4*([Field1]/[Field2])+(0.6*([Field3]/[field4]))

If you do like Michael suggests, don't forget about using Nz to handle nulls and IIF statements to handle division by zero (0).

I'd still like to see the exact expressions being used so we can really tell what you need.

 

[imright]

This is the first expression: Expr1: IIf([DAYS LATE]<=0,0,1)
Second:Expr2: 100-([Expr1]/[Count Of Suppliers])*100
Third:Expr3: 100-([Rejects]/[Count Of Suppliers])*100
And Last which gives me what I need: Expr4: ([Expr2]*0.4)+([Expr3]*0.6)
I need the first expression because the table has some due dates and dates received. I need a count of 1 if late and 0 if on time.
The second expression is for the total late/count received
The third expression is total rejection/count received.
There can be a 0 in the formula and quite often there is.