Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Summing Columns

EclayEclay Member Posts: 26
I am having issues trying to do something in Access. I would like to sum the total of a certain column in order to include it in another table. Anyone have any ideas?

Comments

  • dokken2dokken2 Member Posts: 532
    : I am having issues trying to do something in Access. I would like to sum the total of a certain column in order to include it in another table. Anyone have any ideas?
    :

    There's a number of ways to do it with VBA, DAO, or ADO, the easiest may be with two queries, one that sums a field and another to insert it into another table. see examples in Sql-

    Query1 - SUM a field in Table1

    SELECT Sum(Table1.MyField) AS SumField
    FROM Table1;


    Query2 - INSERT [append] SUM to Table2

    INSERT INTO Table2 ( t1 )
    SELECT Query1.SumField
    FROM Query1;

Sign In or Register to comment.