DSUM & Joins

[Ken]

Can you use DSUM and in place of a table name put a join statment?

Something like:
DSum("BPV_Economic", "tblUnits_ComboGroups INNER JOIN tblUnits ON
tblUnits_ComboGroups.SubUnitID = tblUnits.UnitID",
"tblUnits_ComboGroups.MainUnitID =" & UnitID)

Thanks.

 

[Ken]

Too bad you cant put the join in. Thanks for the answer.