Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: vinhtang
  • Content: Threads
  • Order by date
  1. vinhtang

    sum of rate for each account ?

    Hi all, What I need is to get the total rate for each account and write it to a new table with that distinct account# (strap) & its total rate. table: parcel_tax strap tax_dist 12345 001 12345 002 12345 003 12345 004 01111 001 01111 007 01111 003...
  2. vinhtang

    do calculation base on 2 fields from 2 different tables

    Hi, What I have to do is to calculate the total rate for each code (in table 2) and insert that total rate field in that same table (2). I've never written any SQL codes except for simple select statements. Any help is greatly appreciated. Table1: CD Rate 001 1.5 002 1.25 003 0.5...

Part and Inventory Search

Back
Top