AnsweredAssumed Answered

Avoiding repetition

Question asked by annoici on Nov 26, 2014
Latest reply on Nov 26, 2014 by Stephen Huston

Good morning all,


A question – my first – so please be gentle with me as I am sure there is quite a simple solution to my novice query.


I am creating a database to track Powerpoint slides used in various presentations.


For example say I have four fields and the following three records:

Lecture A | Location X | 10/10/2014 | 10 slides

Lecture B | Location X | 04/11/2014 | 20 slides

Lecture C | Location Y | 10/10/2014 | 15 slides


I would like to create a layout that summarises this information in three lines. So I only want one instance of each lecture not 10, 15 or 20. I can find workarounds but I feel there has to be a more elegant method than mine.