Summary Field accross two tables
I am trying to produce a report involving summary fields and all is going great, except for one thing. I would like a summary field that show the count of a certain field that appears in two different tables. I can produce a report for each table that shows the correct summary count of the fields in question, but is it possible to have a summary field that summarises the summary fields in two different tables? I have tried all sorts of variations (creating new field that counts the two summary count fields etc) and nothing seems to work.
Any help would be greatly appreciated