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

Ask a Question

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.