Easy way to View Totals?

  • dtoakley

    SSC Rookie

    Points: 34

    Hello everyone-

    We recently migrated from Access to SQL 2000. We have a very complicated form that we use in Access, and some of the data in the form is dynamic pulling data from a "View Totals" query. The view totals query is based on another query, and i'm having a heck of a time trying to write T-SQL for these total queries. I failed to mention that we are currently using Access as the front end since we have our detailed forms in access. is there an easy way to do SUM, FIRST, LAST, GROUP BY, etc. type queries in SQL Server? Thanks for any insight...

    Dave Oakley

    david.oakley@mjassociates.net

  • Andy Warren

    SSC Guru

    Points: 119694

    First and last are not supported in TSQL. Aside from that you can do group by, sum, avg, etc, with no problem. Conceptually it may help you to create a view from your sub query, then query it. If you post what you're trying to do we'll try to help.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply