Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

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

Discussion in 'Information Technology' started by kskaug1, Jul 28, 2006.

  1. kskaug1

    kskaug1
    Expand Collapse
    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?
     
  2. Loading...


  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    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.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "kskaug1" <kskaug1@discussions.microsoft.com> wrote in message
    news:3BC6CDB1-EB60-4241-816D-3AEA2CFD3E60@microsoft.com...
    > 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?
     

Share This Page