I need some help . I have a master table showing demographic info (i.e. name address etc). I have another table showing skills of each member and another table showing other languages spoken and a final table showing the total hours volunteered for each year.
I wanted to bring information on skills, languages, hours and some demographic info into one report. The volunteer employee number is in all tables. I created a view including all the tables. The report was designed in Report Designer. I have the demographic info in a Header Section and Skill, Languages, and Hours in columns in the Data Section. The problem I have is one record may list 5 skills, 2 languages and 3 years of hours. When the report prints, the 5 skills are listed and the languages listed are not 3 but 5 as some are repeated and 5 years of hours are also listed with repetition to make up 5 entries. How do I get Skills, Languages and Hours to list unique values i.e. Skills should list the 5 Skills, Languages should list the 2 languages and Hours should list the 3 years of hours. Appreciate any help. Duncan
