Totalling Related Tables
Posted: Thu Sep 22, 2005 7:41 am
I have what on the surface appears to be a simple totalling problem and beleive I must be missing something very simple.____I have created the situation with Sample tables and can email a Zip file with sample data and report showing the situation, if anyone can help then please answer showing your email address.____What I cannot seem to do is create independent totals for the Master Table and the Related table, what happens is that the related table totals become multiplied by the number of records in the Master table.____I have tried various options within the totalling area e.g. using ^SCANNING^ as a condition but this will not help, I have tried greating a group based upon the linking field for both the Master and the Related table.____Prevoiously I have exported totals from 2 separate reports and then picked up the exported tables with a third report and then printed the results as I expect.____Help please this is silly I am sure.