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 Mike Lewis 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. TammyG

    Crystal Reports Do not count Duplicates

    Thanks so much - I GOT IT.....appreciate all your help
  2. TammyG

    Crystal Reports Do not count Duplicates

    Each Patient has a unique MedRecNumber - the problem is I need to count the RaceCd for each MedRecNumber - this is the SQL I have if that helps. I really appreciate all you are trying to do. SELECT DISTINCT "TPM300_PAT_VISIT"."med_rec_no", "TSM040_PERSON_HDR"."lst_nm"...
  3. TammyG

    Crystal Reports Do not count Duplicates

    Thanks for the thought but still not working for me. It is still counting the duplicates even if they are not showing (suppressed). Thanks for trying
  4. TammyG

    Crystal Reports Do not count Duplicates

    I work in Healthcare and need to count "people" who have been admitted to the hospital in the last year by race. My problem is that I can get this to do it by "visit"....a person could have visited the hospital numerous times in the year and I only want it to count once per person. Any help...

Part and Inventory Search

Back
Top