type convertion failure

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
If the ProductID field is a text type, change it to

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

Adding single quote before and after
 
Back
Top