Calculation in DLookUp

[mattstrachan]

Hey all,

I am attempting to perform a calculation while using a DLookUp. I have three tables that will be included. Here is what I would like to do.

I would like to take FingerPrint.TableDiamtr and divide this by FingerPrint.AvragDiamtr. These would be values that come from the FingerPrint table WHERE FingerPrint.ID = Work.ID AND Work.WorkName = Product.ProductID.

The FingerPrint table and the Work table are coming from an external data source that I have set up relationships with the Product table that is in the DB I am creating.

I have used the syntax =DLookUp("Length", "Work", "[WorkName] = Forms!Product![ProductID]") and this works great but I am not sure where to go from there.

Is there a way to perform these calculations with DLookUp? Or could someone recommend a method of completing this?

 

[mattstrachan]

This is now solved, I created a query and used the DLookUp("fieldName","queryName").