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 Chriss Miller 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: rmcintire
  • Content: Threads
  • Order by date
  1. rmcintire

    Summing values across a grooup of fields in each record

    I have a table with a group of fields representing the result of a list of audit questions, with the answers stored as numbers 1,2 or 3 for yes, no, n/a. On a tip from this site I'm using a sum function as follows: =Sum(IIf(1 In ([Rx1],[Rx2],[Rx3],[Rx4],[Rx4a],[Rx4b],[Rx4c],[Prac_notes1]...

Part and Inventory Search

Back
Top