Originally posted by DBlankI am not seeing any immediate 'simple' way to get the data into a group header.
so you are trying to get a total amopunt of people registered but you have hosts in one table and there related guests in another table. A host may have registrered guests but the host is not registered or vice versa, correct?
Actually both the guests and hosts have to register. Here is what the data looks like that I am doing an RT on (showing all data, including what is hidden):
John Doe (Host) Registered
(Detail A): James Smith Registered
(Detail B): John Doe Registered
Tim Johns Not Registered
John Doe Registered
Janice Thomas Do Not Register
John Doe Registered
Philip Smith Registered
John Doe Registered
As you can see, John Doe (the host) repeats, and this is the one I do a (Next) formula to get the running total on. Again, not sure if there is a better way to get that count, but it works.
And for (Detail A), I simply count the ones that are marked "Registered".
I add both RTs together to get total "Registered". Make sense?
Is there not a way to make a summary of field (Host.Registration) to include only "Registered"? Likewise for (Guest.Registration)? This would solve my problem.