Basic DLookup Problem

[Guest]

I have been reading all the Postings but can not find the answer to my
problem. I have a a Table containg Product Descriptions along with our price
for each item. I am trying to calulate a Destroyed Cost when we throw Product
away. In trying to list the Price on my Report, I am using the following in
the Control Source. For some reason I keep getting an Error. Please help.

=DLookUp("[Item Cost]","Description","[Description]=" & [Reports]![Customer
Returns]![Description])

 

[Duane Hookom]

I don't care for DLookup()s in reports and usually try to avoid them.
However, try:
=DLookUp("[Item Cost]","Description","[Description]=""" &
[Reports]![Customer Returns]![Description] & """")

Text/string values must be delimited with quotes.

BTW: is your table name "Description" and your field name "Description"?
This seems ultra confusing.