Access Report Help

Results 1 to 2 of 2

Thread: Access Report Help

  1. #1
    Neil Vacek Guest

    Default Access Report Help

    I am trying to figure out the formula in the report section that will give me the total loans provided for a specific bank. I am looking for the formula that will allow me to sum the total loan amount for say Wells Fargo.

  2. #2
    Join Date
    Dec 1969

    Default SQL

    SQL = "select sum(loans) from banks where bank_name=&#039;Wells Fargo&#039;"<BR><BR>set objrec = objconn.execute(SQL)<BR>response.write(objrec.fiel ds(0).value)<BR><BR>-- Whol

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts