DSUM Help!

[Caryisms]

I am confused about what to insert into this expression DSUM (expr,domain[,criteria]). How do I complete this in query design view? I am trying to add across columns.

col 1 col 2 Expr
Yes Yes =2

 

[JerryDennison]

DSum() is a domain aggregate function. It is normally used to sum a single column for a recordset optionally limited to specific criteria. If you want to total across a row you simply add the values in an unbound column on your query:

Sum: Col1 + Col2

You can total this as well by pressing the Sum button on the query toolbar and changing this field's Total property to Sum.