I love database projects, and would love to be able to query the AC database itself. However, I do not have username/password access to it. There must be a read-only way for practices to access their own data.
Because any AC report involving address seems to time-out for me (possibly due to some corrupt field), I could not use Beagle's method. However, I was able to run a unique household's report, and inner join that to the medicare report (after some name manipulation) and get the report I wanted. So for now the needs are satisfied.
Thank you all.
