Query for a report

[database]

Hi everyone...

I need help with a query which i need to make for a report.

I am making a report where I need to have first name, last name and the topics assigned to a person.

I have two tables
1) info with fields name_id ,first name and last name
2) Topics with fields Name_id,Topic_index, Topic_id ,MainTopic and SubTopic

Each person can have more than one topic.

I need to make a query for the report so that I will have info about the perosn.

I have made a query like this:

SELECT DISTINCT tblInfo.FirstName, tblInfo.LastName, Topics.Topic_id, Topics.MainTopic, Topics.Subtopic
FROM tblInfo INNER JOIN Topics ON tblInfo.Name_id = Topics.Name_id;

With this query, whenever there are more than 1 topic assigned to one person, his name is displayed that many number of times, which is what I dont want.

Can anyone help me with this?
I want the information Firstname and last name displayed only once and then the number of topics.

Please help !!!!!!

Thanks

 

[P_Henry]

I think what you want is grouping - you could use the report wizard which will let you group data for each id / person.