Sumif Equivalent In Access

    I am looking for a SUMIF equivalent utility in Excel. I am running couple of queries to create desired output (which comes into 16 columns in Access). Once this output is generated I need to recalculate values in one of the columns. In Excel I could recalculate those values by using SUMIF formula but I am not sure how to do that in Access.


    I have attached the excel spreadhsheet that shows the final results that I need to generate (it’s from row 20 to row 30 in the attached spreadsheet). I first add some new records to the existing records by running a query and then I need to update column N which is the sum of values (in column L) for each fund code (in column M).


    With the help of people on forums I have figured out how to add new records to existing records by running few queries. But now I am not sure how to change values in column N. As mentioned earlier in excel I can use the “SUMIF” formula to generate the desired results but I am not sure how to do that in Access.


    I would really appreciate if you can suggest a way to do so.


    Thanks for the help.


    Regards,


    Peace

    Re: Sumif Equivalent In Access


    Hi


    I am not certain that there is an equivalent to SUMIF in Access; a workround might be to create a new table for the Fund values and their totals, and then running an update query based on this new table.


    Robert

    Re: Sumif Equivalent In Access


    Peace


    What you really should be looking at is aggregate queries and/or crosstab queries.


    There is no real equivalent of Excel's SUMIF in Access.


    But it can be far easier sometimes to summarise data in Access.

    Boo!:yikes:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login