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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by thomasgill

  1. thomasgill

    Removing Duplicates, but need to sum on distinct records

    I was able to work around the problem, but I'll leave the solution here for future reference. In the running total evaluation formula, evaluate if Next({Patient.Searchname})<>{Patient.Searchname}
  2. thomasgill

    Removing Duplicates, but need to sum on distinct records

    I realized that I could also only evaluate the running total if: the value is in the specified range and the group changes. However I am unsure how to use both of these at the same time in the running total formula.
  3. thomasgill

    Removing Duplicates, but need to sum on distinct records

    Hello. I am building and running reports based on medical records. The report I am working on requires me to pull the most recent value for a test given to a patient, and place it into a range of values. Then I need to sum the total of patients whose last test value was within range a, range...
See more

Part and Inventory Search

Back
Top