Total Only What Matches with DSum

Need a total for just the records that matter? DSum adds a field from a table or query, using criteria to choose which records count. Here the paid orders add up to $200; the unpaid order stays out. Use Nz to show zero instead of Null when nothing matches. Watch the video to add date criteria and build paid and unpaid totals.

For a complete step-by-step video tutorial on this topic, including additional examples and explanations, please visit https://599cd.com/DSum.