Results 1 to 3 of 3

Thread: Column totals

  1. #1
    Join Date
    Aug 2006
    Posts
    27

    Unanswered: Column totals

    Is there no way to display column totals in a form in datasheet view?

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Of course there is a way

    How about something like:
    Code:
    SELECT IDCol, MyVal
    FROM (SELECT Cstr(MyID) AS IDCol, MyVal, 0 AS OrderCol
    FROM MyTable
    UNION SELECT "Total: ", SUM(MyVal) AS Total, 1
    FROM MyTable) AS DerT
    ORDER BY OrderCol ASC
    HTH
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Aug 2006
    Posts
    27
    Thanks a lot.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •