G
G.
I can do this with multiple transitory queries or exporting to Excel and then
importin gback to Acces or by doing Make Table queries, etc. But, there must
be an easier way I am sure.
I have a "Surgery" table with Name of Anesthesiologist, Antibiotic Admin
Time, Surgery Incision Time, and other fields.
I need to create a query that gives me the count of the number of times that
the time difference between the incision time and antibiotic admin time is
less than 60 for each anasthesiologist that I define in the criteria area of
the query.
The anesthesiologists need to be grouped because the same anesthesiologist
could have been on multiple procedures (i.e. I do not have a separate table
for them).
This calculated field in a query is going to be one of a few. Other fields
will be the total # of procedures, # of times over the 60 minute mark, % of
time over the 60 minute mark, average amount of time when over the 60 minute
mark, avg amount of time when under the 60 minute mark, Overall avg. time
difference between incision time and antibiotic admin., and maybe a couple
others.
I can piece this together but it is ugly. Please help, I know there must be
something simpler but the more I think about it the more convoluted my
solutions become.
Thank you for your help.
importin gback to Acces or by doing Make Table queries, etc. But, there must
be an easier way I am sure.
I have a "Surgery" table with Name of Anesthesiologist, Antibiotic Admin
Time, Surgery Incision Time, and other fields.
I need to create a query that gives me the count of the number of times that
the time difference between the incision time and antibiotic admin time is
less than 60 for each anasthesiologist that I define in the criteria area of
the query.
The anesthesiologists need to be grouped because the same anesthesiologist
could have been on multiple procedures (i.e. I do not have a separate table
for them).
This calculated field in a query is going to be one of a few. Other fields
will be the total # of procedures, # of times over the 60 minute mark, % of
time over the 60 minute mark, average amount of time when over the 60 minute
mark, avg amount of time when under the 60 minute mark, Overall avg. time
difference between incision time and antibiotic admin., and maybe a couple
others.
I can piece this together but it is ugly. Please help, I know there must be
something simpler but the more I think about it the more convoluted my
solutions become.
Thank you for your help.