PARAMETER QUERY??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have to find the total number of patient's that received a cath based on
the number of patient's seen.

I have a query that tells me: The total # of patient's who had a cath whose
stress test was postive, the total # of patient's whose stress test was
negative, # of patient whose stress test was a false positive and the # of
patient's whose stress test is false negative.

I need to add the above totals and divide this total by the number of
patient's who received a stress test (whether they had a cath or not). I
currently do not have a column for the Total # of Patient's who received a
stress test. Where would I add this one time total since it will be
different every month.

I was thinking I could add a field in the main table for Pt's seen. Then
create a parameter query that would allow me to enter the total pt's seen and
create an expression that would take all the totals above and divide by the
Total # of Paitent's who received a stress test but I can't get it to work?
HELP???
 
You just need to add a calculated field to your query and let this
calculated field return the total number of patients for you.

If you're using the query grid, something like this, perhaps:

TotalPatients: DCount("*", "TableNameWithPatientData",
"[StressTestDoneField] = True")
 
Back
Top