To June 7 - Hi!
Referring to the thread https://www.accessforums.net/showthr...age-of-a-total in the queries, we have had a longer process in developing a rather complex report. Do you think, now that you know the excact layout of the report, it is possible to make a subreport that can do the job without me having to redesign it all the time - when I enter the datas of a new group?
I have outlined an alternative - just to enter the MaxHours in a data field when entering the datas. This would perhaps be the easiest way now, but it will be an alternative that may be the source of errors when entering datas. But if you think I should consider a subreport to produce the totals for each city, I would start to work on it. As I have said, I think the MaxHours of each group will be the hardest thing to take care of - because I cannot redesign the report all the time for an ever increasing number of groups.
Greetings, Roar58