query calculated field. problem with dsum criteria.

[russ0670]

I am creating a basic stock control query.

I have

1 table which is stockitems.
1 table which is orders
1 table which is stockdelivery.



I have created a query based on the stock items table and have created an expression to show the amount of stock in total that has been ordered. but I cannot seem to get it correct.

I have tried two different code lines

TotalPurchased: DSum("[NumberOfItems]","[StockDelivery]"," [ITEMDescription] = """ & [Description] & """")

Does not display anything in the field when the query is viewed.

TotalPurchased: DSum("[NumberOfItems]","[StockDelivery]"," [ITEMDescription] = " & [Description])

Displayer error in the field(syntax error) missing operator.

Both [ITEMdescription] and [description] are text fields and [numberofitems] is a number field(double).

Can anyone see what I am doing wrong.

[russ0670]

not a prob with the criteria, just list box was bound to the wrong column