K
Kate
Can I create a parameter query that will do the following.
Take the SUM totals of columns 1 through 4 and divide this by a number
parameter that I would enter that is always changing.
EXAMPLE:
Total number of patient whose test was positive + total number of patients
whose test was negative+ total number of patients whose test was a false
positive + number of patients that were false negative DIVIDED by total
number of patients seen.
Do I have to create a field or table that includes the total # of patients
seen and this is something that is added on the fly and is always changing?
Or do I create a field within the main table called # OF PATIENT'S SEEN.
that I would only use in a paramter query? I am at a loss, on how to
accomplish this.
Thanks
Take the SUM totals of columns 1 through 4 and divide this by a number
parameter that I would enter that is always changing.
EXAMPLE:
Total number of patient whose test was positive + total number of patients
whose test was negative+ total number of patients whose test was a false
positive + number of patients that were false negative DIVIDED by total
number of patients seen.
Do I have to create a field or table that includes the total # of patients
seen and this is something that is added on the fly and is always changing?
Or do I create a field within the main table called # OF PATIENT'S SEEN.
that I would only use in a paramter query? I am at a loss, on how to
accomplish this.
Thanks