(duplicates identified by date+time+teachers name)
What will you do if you get two teachers with the same name?
two options you can try:
By changing the body of your layout into a sub summary part, you can show one record per group of records by placing these fields in the sub summary part "when sorted by" time. THen you sort your records by teacher, date, and then time.
The other options is to set up a looping script that omits the duplicates. This is the same basic idea as a delete duplicates script, but you omit the duplicate instead of deleting them.
Thank you Phil ... The first option is more appealing because the looping script will take time for a big file. Whowever correct me if I am wrong: with the first option I would not be able to print a correct total at the end. If this staement is correct I am stuck with the second option.
By the way I said teachers name but actually it is teachers code, where every teacher gets a unique code.
A correct total of what? It should be possible, but how easy that is to set up depends on what you are summing or counting to produce that total.
total of sessions taught which is in this case the count of lines displayed on the report not the count of records