Re: complex filter and calculations in access
- From: Marshall Barton <marshbarton@xxxxxxxxxx>
- Date: Thu, 09 Mar 2006 12:02:29 -0600
DrTominRI wrote:
I don't really think this is that complex. My medical database includes
mixed data, text, numbers, yes/No's etc Specifically, patients that have
undergone a specific operation by a specific surgeon, some have certain risk
factors and some have had certain complications. I can certainly filter to
get all of the patients who have had an appendectomy/by Dr Kildare/who have
diabetes/and got and infection/ But how do I calculate Dr Kildare's overall
infection rate? How do I make the query count Just all of Dr Kildares
operations, and use that as a denominator. How can I compare his infection
rate in diabetcs vs non diabetics?
Please help, my local exper says I need to export it all to excel and do it
there.
You will probably want to use queries of queries or
subqueries for some of that, but, as Karl said, we need to
know your table structure.
If your "expert" thinks Excel is the way to do this, s/he's
probably an "expert" in Excel, not in Access/SQL.
--
Marsh
MVP [MS Access]
.
- Prev by Date: Memo Field Data being truncated with agregate function
- Next by Date: Re: join typecast
- Previous by thread: Memo Field Data being truncated with agregate function
- Next by thread: Re: complex filter and calculations in access
- Index(es):
Relevant Pages
|
