• Yeah, Haz is Hazards or Hazardous

    You can use the DLookup function to get the value of a particular field from a specified set of records (a domain). Use the DLookup function in a Visual Basic for Applications (VBA) module, a macro, a query expression, or a calculated control on a form or report.

    You can use the DLookup function to display the value of a field that isn't in the record source for your form or report. For example, suppose you have a form based on an Order Details table. The form displays the OrderID, ProductID, UnitPrice, Quantity, and Discount fields. However, the ProductName field is in another table, the Products table. You could use the DLookup function in a calculated control to display the ProductName on the same form.

    So in mine....

    ACost: (DLookUp("[Cost]","tblArboristType","[ArboristType] = 'A'"))*[A]

    I am looking at the field "Cost" in the table "tblArboristType" where the "ArboristType" = A (You probably got that though)

    In my case there will only ever be one record where the ArboristType = A, so I don't care if it only finds the first one.