AnsweredAssumed Answered

Find unique or distinct records?

Question asked by Flyfisher2611 on Feb 19, 2017
Latest reply on Feb 19, 2017 by siplus

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

Outcomes