Can I write a sumif formula in Access? If so, how?

[Guest]

I am trying to write formulas in Access and am having trouble writing sumif
and if(and formulas in Access? If this can be done, how do I write the
formula & set the range?

 

[Douglas J Steele]

Access is very different than Excel. To use it successfully, you're going to
have to realize that, and not expect that you're going to be able to migrate
Excel concepts.

While the grid you see in Access may look like a spreadsheet, it isn't. You
have to get used to using Queries, rather than expecting to work with
ranges.

One way to get the equivalent of a SumIf would be to use the DSum aggregate
function with an appropriate criteria. Another would be to use a query.