Hi ,I am having considerable bother in getting a report to behave how I wish and therefore to be able to total fields etc. I have posted quite a few isolated questions on reports recently and am perhaps guilty of not making myself clear. I have a main table with say main ID, from this I have a many scheme table with schemeID. Scheme has two many to many relations with risks and checks. I have created appropriate junction tables for each. I have combined all these in one query to show all records.
On my report I DO want groupings but have an issue around how I model the two junctions since they are at the same level in terms of relations so I do not one grouping over the other. If I consign these to the details section I end up with mutliple lines, so if I have 2 risks and 3 checks I end up with six lines which is not what I want and is confusing to the reader, (first risk is shown 3 times each with one of the checks next to it, then similarly for the second risk . I need the 3 risks showing in isolation and similar the 2 checks but obviously linked to the appropriate scheme. Suggestions would be most helpful.
Many thanks, Darren.
