https://www.infopathdev.com:443/forums/47.aspxFor questions concerning issues in the integration of SQL and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/17411.aspxMon, 20 Nov 2006 18:06:17 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:17411Greg Collins0https://www.infopathdev.com:443/forums/thread/17411.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=17411Michael, please see my response in your other thread.https://www.infopathdev.com:443/forums/thread/16858.aspxMon, 20 Nov 2006 17:10:46 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:16858Michael710https://www.infopathdev.com:443/forums/thread/16858.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=16858Can this Xpath work <br />sum(xdXDocument:GetDOM("TOSSReceive")/dfs:myFields/dfs:dataFields/d:TOSS[xdXDocument:GetDOM("TOSSReceive")/dfs:myFields/dfs:dataFields/d:TOSS/@employeeDepartment = ../../dfs:dataFields/d:TOSS/@employeeDepartment]/@monthlyExpenses)<br /><br /><br /> or is it best to edit the SQl connection to do this