SQL inside DLookup()

[jgelpi16]

Forgive me but I thought this would be something simple. I am trying to execute a piece of SQL inside a DLookup(). Is that possible? I keep getting a run-time error when I try to execute.

        mySQL = "SELECT * FROM tblSKUMin_Max WHERE [SKU] = '" & vSKU & "';"
        vMin = DLookup("SKUMin", mySQL, "[SKUClass] = '" & vStoreClass & "'")
        vMax = DLookup("SKUMax", mySQL, "[SKUClass] = '" & vStoreClass & "'")
        Form_SfrmEmail.txtMedMin.Value = vMin
        Form_SfrmEmail.txtMedMax.Value = vMax

Error States:
"The Microsoft Acces database engine cannot find the input table or query 'SELECT * FROM tblSKUMin_Max WHERE [SKU] = '(SKU NUMBER)';'. Make sure it exists and that its name is spelled correctly."

[ajetrumpet]

the second argument is a table or query name, sir. you can't do what you're doing.

to be sure though, look the function up in VBA help and read the description of the arguments. if sql statements are accepted, it will say so. I'm 99 sure though, that it won't say that.

makes sense too, actually....that would require the engine to do two tasks at once that are complicated. that's prrobably the rationale...

[jgelpi16]

Understood. Thank you.