By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,480 Members | 2,192 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,480 IT Pros & Developers. It's quick & easy.

Report duplicates

bimos
P: 11
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!
Feb 20 '07 #1
Share this Question
Share on Google+
7 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
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
Feb 20 '07 #2

bimos
P: 11
Sure here it is


Expand|Select|Wrap|Line Numbers
  1.  
  2. SELECT[List of Companies].[Company Name],[List of Products].Product, [Company Comments].[Date entered], [Company Comments].Comment
  3. 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]
  4. GROUP BY[List of Companies].[Company Name],[List of Products].Product, [Company Comments].[Date entered], [Company Comments].Comment
  5. HAVING ((([List of Companies].[Company Name])=[Forms]![Main Form]![compselect]));


thank you in advance!
Feb 20 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Feb 20 '07 #4

bimos
P: 11
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
Feb 20 '07 #5

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Feb 20 '07 #6

bimos
P: 11
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 :)
Feb 20 '07 #7

MMcCarthy
Expert Mod 10K+
P: 14,534
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!
Feb 21 '07 #8

Post your reply

Sign in to post your reply or Sign up for a free account.