DSUM & Joins

K

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.
 
M

Marshall Barton

Ken said:
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)
Click to expand...


No, but you can create a query with the join:

Query1:
SELECT BPV_Economic, MainUnitID
FROM tblUnits_ComboGroups INNER JOIN tblUnits
ON tblUnits_ComboGroups.SubUnitID = tblUnits.UnitID

and then use DSum on that:

DSum("BPV_Economic","Quer1","MainUnitID=" & UnitID)
 
Top