Print no duplicates

[access2010]

We have tried many times to use this report and not print any duplicate = Symbol_Stock_Y = codes without any success.

Could you please assist us with this problem?

I presume we can use the same code for the report = Stock_PortfoliobyAsset_Sergey_NamesR = and not print any duplicate = Stock_Names =

Your suggestion will be appreciated.
Nicole

 

[pbaldy]

I would expect you to change your query to a totals query (icon on ribbon) and group on that field. Your query returns many fields that don't appear to be used, so cut it back to what is required, and choose the appropriate Total option for each. I'd expect Group By for the symbol and perhaps Sum for an amount field?

 

[ypma]

in addition to PBaldy's advise. Have you considered using the hide duplicate option in the properties drop down of the each field . Plus grouping by in the header and footer' I have had a play with it and will upload my effort , which is not perfect, but might point you in another direction to achieve your aim '

Other members might have an opinion on using this method and hope they will respond.

Regards Ypma