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: *

  1. rmcintire

    Summing values across a grooup of fields in each record

    Thanks fneily. I am familiar with the use of the IN qaulifier in a Select stmt. I first attempted this as a select stmt, but received errors about about the expression. I was advised to use it in the aforementioned function stmt in an unbound text box on the report. This seems like a clean...
  2. rmcintire

    Summing values across a grooup of fields in each record

    THanks for your reply, dhookum, but that would require a complete redesign of a db / app, which I inherited. That's not doable. I think I'm pretty close to a workable solution with that Sum ( iif ( 1 in field list )function, but can't determine why it's prompting for a parameter value for...
  3. 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