SQL for report

Discussion in 'Access VBA Modules' started by Lasitha, Jan 10, 2012.

  1. Lasitha

    Lasitha Guest

    Hi have query call "ADVBNK"

    TBANK TMBOC TMBRAN BANKAMT ROOT
    BC CSH KLW 1637770 CL
    BC BNK KLW 2434260 CL
    SB BNK KLW 1099350 CL
    BC BNK DOD 582650 CL
    BC BNK KLW 661370 EH
    BC BNK KLW 2050160 CL
    COM BNK KLW 750920 PMB
    PB BNK KLW 678870 CL

    in this table I wonna get the sum of "BANKAMT" by filtering

    "CL" form "ROOT"
    then "BC" from "TBANK"
    then "BNK" from "TMBOC"
    then "KLW" from "TMBRAN"
    to specific Text box of report

    pls tell me how to do it with SQL statement of another easy way
     
    Lasitha, Jan 10, 2012
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Chris Nebinger

    Multiple SQL Statements - Access Linked To SQL Server

    Chris Nebinger, Jul 12, 2004, in forum: Access VBA Modules
    Replies:
    0
    Views:
    144
    Chris Nebinger
    Jul 12, 2004
  2. Mike
    Replies:
    4
    Views:
    237
  3. Jael

    Logical Operations in a report SQL

    Jael, Aug 16, 2006, in forum: Access VBA Modules
    Replies:
    4
    Views:
    91
  4. Mike

    Newbie: Access SQL and SQL and MS SQL

    Mike, Nov 16, 2006, in forum: Access VBA Modules
    Replies:
    4
    Views:
    271
    Granny Spitz via AccessMonster.com
    Nov 18, 2006
  5. mallik
    Replies:
    1
    Views:
    86
    Marshall Barton
    Jul 12, 2007
  6. Cyberwolf0000 via AccessMonster.com

    OpenRecordset SQL using wrong SQL statement

    Cyberwolf0000 via AccessMonster.com, Dec 29, 2008, in forum: Access VBA Modules
    Replies:
    7
    Views:
    249
    Tony Toews [MVP]
    Jan 1, 2009
  7. Jonathan

    >> building a sql database from another sql database

    Jonathan, May 26, 2009, in forum: Access VBA Modules
    Replies:
    2
    Views:
    165
    Chris O'C via AccessMonster.com
    May 27, 2009
  8. ryguy7272
    Replies:
    15
    Views:
    308
    vanderghast
    Jun 22, 2009
Loading...