Report duplicates

[bimos]

Second issue of the day ...

I have a report submitted to a query
In the report I should have Company, many products, many dates and comments.
The problem is I always end up with duplicates.
Isn't there a way to "hide duplicates" for each group???
How can I solve this problem ???

Hope someone can spare 2 micro seconds for me!

[MMcCarthy]

Second issue of the day ...

I have a report submitted to a query
In the report I should have Company, many products, many dates and comments.
The problem is I always end up with duplicates.
Isn't there a way to "hide duplicates" for each group???
How can I solve this problem ???

Hope someone can spare 2 micro seconds for me!

I would need a lot more information. Can you post the query sql that the report is based on?

Mary

[bimos]

Sure here it is

 
SELECT[List of Companies].[Company Name],[List of Products].Product, [Company Comments].[Date entered], [Company Comments].Comment
FROM ([List of Products] INNER JOIN ([List of Companies] INNER JOIN [Company Demand] ON[List of Companies].[Company Key] = [Company Demand].[Company Key]) ON[List of Products].[Product Key] = [Company Demand].[Product Key]) INNER JOIN [Company Comments] ON[List of Companies].[Company Key] = [Company Comments].[Company Key]
GROUP BY[List of Companies].[Company Name],[List of Products].Product, [Company Comments].[Date entered], [Company Comments].Comment
HAVING ((([List of Companies].[Company Name])=[Forms]![Main Form]![compselect]));

thank you in advance!

[MMcCarthy]

Ok so company will have many products. In a report you will need to set the Company Name as a group header and put the date and comment in the footer of this header. You can see the multiple products per company in the detail section.

Mary

[bimos]

Thank you !


It works ok , the only problem now is that I can see only one comment or date!
Is this a grouping setting that I miss?


Alex

[MMcCarthy]

Thank you !


It works ok , the only problem now is that I can see only one comment or date!
Is this a grouping setting that I miss?


Alex

Sorry Alex I didn't realise there was more than one.

You will have to do this with a subreport as there is no relationship between comments and products there is no way to group them.

Mary

[bimos]

I'll handle it from here!
Subreports are not cool but they do the job :)
Thanks for everything

Thank You!

PS if you need anything just PM :)

[MMcCarthy]

I'll handle it from here!
Subreports are not cool but they do the job :)
Thanks for everything

Thank You!

PS if you need anything just PM :)

You're welcome!