Report with 2 data sources

[Guest]

Hi All,

I need some help with a report I am trying to modify. I have an existing
report that show number of visits per patient for the last 12 mths. On that
same report I would like to add total number of visits (ever) for patients
who have visited the hospital in the last 12 mths. I have built a second
query to pull all visits for patients.

Can my report be linked to 2 different queries? If I add a count from my
second query to the report and run it prompts for records I want to pull.
How can I get rid of the prompt?

Let me know if you more explanation in order to help me out.

Thansk,

 

[Guest]

Consider using a subreport that is linked on the patient ID or whatever field.