Why is our report printing duplicate records? (1 Viewer)

[access2010]

Could I please receive an idea as to why our report (using Access 2003) is printing the same record multiple times and how we should fix this problem?

Thank you

Nicole

 

[CJ_London]

check your query, you are linking on symbol_stock. There are 15 of these in one table and 3 in the other, so the data will repeat 45 times.

You have not set up relationships so difficult to know what is supposed to happen, but looks like your purchase sales table needs a FK to the investment table

 

[access2010]

Thank you, CJ for your note.
I have never used a FK (foreign key), how would you suggest to do this for our report, to show the records as in the attached Pdf?

Thank you,
Crystal

 

[CJ_London]

As said, not sure what your relationships are so difficult to advise.

 

[access2010]

Thank you CJ for your mentioning of our relationships.
I think that we have found the problem with multiple records.
How can I continue to use our table = Investments01_tbl
And use the field = OneRecord_Research = as a filter
To group only the records that have the word = Research = in them
I do appreciate your assistance

 

[CJ_London]

use a criteria. either

WHERE OneRecord_Research='Research'

where it just has that one word

or

WHERE OneRecord_Research Like '*Research*'

where it is one of the words - e.g. 'Initial Research'

then change the query to an aggregate (group by) query

 

[access2010]

use a criteria. either

WHERE OneRecord_Research='Research'

where it just has that one word

or

WHERE OneRecord_Research Like '*Research*'

where it is one of the words - e.g. 'Initial Research'

then change the query to an aggregate (group by) query

Thank you, CJ London, for leading me to a great new faction, an Aggregate Query.
I have created the query in the attached database, but have not been able to connect the = Investments01_Q_Aggregate = to the form and report.
Would you please be kind enough to correct the attached database for us?

Thank you,
Crystal