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