Report with 2 data sources

N

Natalie

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,
 
D

Duane Hookom

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top