4 Replies Latest reply on Feb 19, 2017 12:48 PM by siplus

    Find unique or distinct records?

    Flyfisher2611

      Hi

       

      I am having difficulty in creating a list of plants in my report. I can create a list of every batch I am growing, but I wish to present the report as a product list, that is to say, that I only want to show a line for each of the products I am growing, for example

       

      Lobelia Crystal Palace  - 6 pack

      Lobelia Crystal Palace  - 9 pack

      Lobelia Rosamund - 9 pack

      Lobelia White Lady - 9 pack

       

      not

       

      Lobelia Crystal Palace  - 6 pack

      Lobelia Crystal Palace  - 9 pack

      Lobelia Crystal Palace  - 9 pack

      Lobelia Rosamund - 9 pack

      Lobelia Rosamund - 9 pack

      Lobelia White Lady - 9 pack

       

      I used to use Lotus and in that it was easy! I'm not sure why there isn't a function to do it, but obviously, there isn't!

       

      I have looked through the forum, but to be honest, I'm struggling to pick the bones out of it! I am not familiar with SQL.

       

      Any help, as usual, will be greatly appreciated!

       

      Kind regards

       

      Alan