Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Exaggerated Total

Status
Not open for further replies.

fsub

Programmer
Feb 2, 2006
60
US
Hi..

In CR8.5, how do you avoid a cartesian product? I have 2 tables. Amounts on tableA are totaled and so are amounts in tableB. Total of TableA is exaggerated.

Thanks
 
These are MS-Access tables with an equal join. Join type is grayed out so I cannot really experiment with different joins.
 
In that case, if you can (allowed to). Create a query in Access with the two tables joined, then create a report using the query as a data source. I believe you find it works better.

I hope this helps.
 
Thanks Kray. Creating a query was an attractive solution. I tried it but my query resulted in duplicate records. These tables are laid out differently with a few common fields.
 
Are the entire rows duplicated? If so you should be able go to Database, Select Distinct Records. If the row is not totally duplicated. Then you may need to do some grouping and hide the details. Without knowing the database, it can take some time.

I hope this helps.
 
Yes, the entire row is duplicated. Unfortunately, the 'Select Distinct Records' is grayed out in both Database menu and Report Options. I am looking at grouping now.
 
I formulated and grouped by a RecordID. It worked well. Thanks for the tip.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top