I have a report, stemming from a query, based on 2 tables. I need to have just certain accounts in the query that I want in the report. As soon as I run the report or query the results seem to multiply many time (sometimes duplicates, triplicates etc). I posted this earlier this summer under queries and have not been able to get back to it till now. Someone there suggested I needed to approach it from the report standpoint. Their thought was to sum () some column from the "1" side of the "1 to many relationship". The subreport would use only data from the "1" side and the subreport would use only data from the "many" side. I have tried to build a report and subreport as suggested and the subreport does not have any returns. When I run the report it just keeps asking for the [start date], over and over, then if I click cancel I get the title of the subreport (rsubactions). Also, to sum the field I removed when I changed the group by operator to Sum for the field I want to sum and run query it returns, "Can't group on Memo or OLE object tbl.Actions.comment.
Where should I go from here? Help would be greatly appreciated....
Where should I go from here? Help would be greatly appreciated....
