Report Probelm

[ekta]

I have to make a report based on 3 tables.
1. tblBusinessOpportunity (OpportunityName, BusinessLead)
2. tblActionItem (ActionItem, ActionItem_Date)
3. tblNotes (Notes, Note_Date)

Table Business Opportunity has a one-to-many relationship with both tblActionItem and tblNotes table. To create this report I created a query and added the fields mentioned above. The report works fine but the problem is that if an opportunity has 2 action items associated with it the report shows the Opportunity twice and then lists action items, which makes the user think that these are 2 separate records. Is there a way to show the opportunity name only once and under action item list 2 actions one below the other?

Thanx
Ekta

 

[Hayley Baxter]

If I am understanding your question correctly you need to go into design view of the report and right click the field for opportunity name then choose the format tab and set the hide duplicates to Yes. This should then give you the opportunity name once only but multiple actions and notes.

If I have misunderstood you please let me know.

Hay

 

[ekta]

Thx Hay

That's exactly what I wanted.

Ekta