using dlookup on report to get a cost from a table associated with another field in a report

[CurtisC]

I have a table for equipment that lists the code, description and cost
this equipment is used on calls that are entered on a form where the user can select the items used and enter the quantity
on the report which gives the cost estimate for the job I have pulled in the equipment and quantity fields and im trying to put a field in for the per unit cost that is associated with the equipment used
in the control source i have:



=DLookUp([Equipment]![Unit_Cost],[Equipment]," [Equipment]![Item_Description] = " & [Report]![Equip_Used_1])

but it asks me for a parameter value for Equipment and then displays #Error in the field under Cost Per

[CJ_London]

all the dlookup parameters are strings try

=DLookUp("Unit_Cost","Equipment","[Item_Description] = '" & [Equip_Used_1] & "'")

[ranman256]

remember, strings get quotes
numbers do not:

string:

"[Item_Description] = '" & [Equip_Used_1] & "'"

numeric:
"[id]=" & txtID

[CurtisC]

you are awesome thx