Syntax for DSum function for Currency fields

[valley]

I have a Number field with value as
DSum function where the criteria is
Textfield which works well.

=DSum("[MCRef]","Miracle_Cloth_Main","[Cust_ID]='" & [Cust_ID] & "'")

It doesn't show the SUM when the type of
textBox is CURRENCY

Can anyone suggest IF Ineed to change the syntax ?

 

[pbaldy]

http://www.mvps.org/access/general/gen0018.htm

 

[valley]

Many thanks for the URL, but I couldn't see the usage for CURRENCY type of data under the examples.
in my case I have used
=Format(DSum("[Discount]","Miracle_Cloth_Main","[Cust_ID]=" & [Cust_ID]),"Currency")

Where [Discount] is currency and [Cust_ID] is string.
and the field where the aggregate is going is of CURRENCY type.

Even with the the above expression, I don't get any result.
Are there any examples of this type which I imagine must be a common usage.