Search results

  1. M

    Sum Group By

    Anyone who is able to help with a solution?
  2. M

    Sum Group By

    Thanks for this However, it does not work as a query as well. Wish I couldve done this in Excel.
  3. M

    Sum Group By

    Thanks for your reply. I have a very large dataset that needs sifting. For instance there are equal and opposite entries, i.e. debit and credit entries in 2 columns that may relate to the same product (say col3). Hence I need a sumif equivalent to get rid of products that have net zero balance.
  4. M

    Sum Group By

    Hi I'd like to use a formula similar to SumIf in Access. I have column 1 with product names and col 2 with Totals. I would like to show totals for each product in col2. Just unable to make this happen :banghead: I've used code like this - DoCmd.RunSQL "UPDATE Table1 SET Table1.Col2 =...
Top Bottom