Repetitive Fields

[Mahoney]

Hello Everyone,

I have many tables for certain tasks, for a certain job.
The tob has an ID number, the title of the program episode title duration etc..

The tasks table are for example, translation, proof reading, typing directing, audio mixing voice over.
Now for each program, mostlyone translator, one proof reader one director, however there are many voice overs (people)

I want to create a report for all the people that paritcipated in the tasks of a single program, everything is fine with all the people except for voice over, when I create the report, it shows the translator the director the proof reader, but what is happeneing is it keep repeating the name of the translator and the director, as many number of different vcoice over talents. For example there are 5 different voice over talents, it will repeat the same director 5 times the translator five times as if it is a completely new record on the report.
I was able to do it by adding a subreport on the main report, but this is slowing down the whole database and i will not be able to print a certain report for a certain program

I really appreciate you help
thanks

 

[Rabbie]

Look up Grouping and Sorting for reports in Access Help

 

[Mahoney]

Thanks for you note, however its not what i want.
Grouping will help me in finding which program each talent recorded in but no the opposite, if I group by the title of program or program ID, it is repeating the record as many times as there are voice over talents

 

[Rabbie]

Hmm. Any chance of you posting your Db with some sample data so I can see what can be done.

 

[Mahoney]

Many thanks Rabbie,

Dont want to hassle you (yet), am trying to figure it out
lets see how it will work

thanks again

 

[gemma-the-husky]

this probably relates to the way you are preparing your query

you probably need separate queries for each "talent", adding a talenttype (function) column.

then union them together to get a single query that looks like


filename talenttype talent
A Film Director Spielberg
A Film Producer Lucas
A Film Voice Hanks
A Film Voice Ryan
A Film Voice Witherspoon

etc

is this what you currently have?