Hi all, I've been struggling with syntax for multiple DLOOKUPs inside of nested IIF statements. I'm wondering if anyone can help.  

Here is some background:
This is for a marina that offers various services for boats, including repairs, maintenance, winterization, etc.  I'm trying to auto assign pricing to various services, but the price of a particular service depends on the boat. (For example the type of engine, the horsepower, etc.)  I have a table called "Boats", that stores boat info and a form called "BoatsForm" for data entry, viewing and editing.  I have a table called "ServicePricing" which stores the names of services offered and the price for each service.  

The field called "service" is short text.
The field called "price" is currency.

In this example, there are 3 separate prices for engine winterization, depending on type and horsepower:
Outboard 2 Cycle with 10 HP or less
Outboard 2 cycle with 25 HP or more
Outboard 4 Cycle regardless of HP

If the enginetype is "Outboard 2 Cycle" and the HP is less than or equal to 10, I want to lookup the price for the service named "WintEngOutboardUpto10HP2Cycle"
If the enginetype is "Outboard 2 Cycle" and the HP is greater than or equal to 25, I want to lookup the price for the service named "WintEngOutboardOver25HP2Cycle"
If neither of the above are true I want to lookup the price for the service named "WintEngOutboard4Cycle"


I have an unbound text box on the BoatsForm whose control source is the following:

<CODE>=IIf("enginetype = 'Outboard 2 Cycle'" And "OuboardHP <= 10",DLookUp("Price","ServicePricing","Service = 'WintEngOutboardUpto10HP2Cycle'"),IIf("enginetype = 'Outboard 2 Cycle'" And "OuboardHP >=25",DLookUp("Price","ServicePricing","Service = 'WintEngOutboardOver25HP2Cycle'"),DLookUp("Price","ServicePricing","Service = 'WintEngOutboard4Cycle'")))</CODE>

It's not giving an error but it keeps returning the price for "WintEngOutboardUpto10HP2Cycle" no matter which values I choose for enginetype and OutboardHP on the form. (dropdowns)

Any help is appreciated.

Thanks,
Kyle