type convertion failure

[Guest]

The following sample from Access 2003 doesn't work if the key joined fields
are text:

DSum("[Quantity] * [UnitPrice]","Order Details", "[ProductID]=" &
[ProductID])

Does anyone knows why?

Thanks!

 

[Guest]

If the ProductID field is a text type, change it to

DSum("[Quantity] * [UnitPrice]","Order Details", "[ProductID]='" &
[ProductID] & "'")

Adding single quote before and after