SQL for report

L

Lasitha

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
 

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. After that, you can post your question and our members will help you out.

Ask a Question

Top