DSum in Query - Adding groups

[Huddle]

I have a table with a list of buildings, I have another table with a list of Posts. I have both of these tables connected by a third table.



I ran a query that gives me a list of combined information including Building Number, Post Number and a Inspection Number from the Post table.

I want to add up the Inspection Numbers for each Building. I thought I could use a DSum but I can't seem to get it to work.

See the attached

[ajetrumpet]

if you want to group a column, like building numbers and use a mathematical operation on them, you have to group it with an aggregate function, NOT a domain aggregate, so try something like:

select buildingnum, sum(otherfield) as [sum of grouped building codes] from table

group by buildingnum

domain aggregates (e.g. - those that start with 'D' and do math stuff) don't ever need GROUP BY clauses.