Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005
    Posts
    5

    Question Unanswered: Removng Duplicates from a Report?

    Hi

    Is there any way in a report to hide duplicates for example in the image attached, the SchoolID ComboBox and the UnitCode ComboBox and the LecturerID Combo Box for a particular record all match thoes fields in another record?


    Hope someone can help
    Kind Regrads,
    John Eliot
    Attached Thumbnails Attached Thumbnails reportWizard.jpg  

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    First off...why are you using ComboBoxes in your report?

    In your report query consider using SELECT DISTINCT blah blah blah

    .
    Environment:
    Self Taught In ALL Environments.....And It Shows!


Posting Permissions

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