Rabbit/NeoPa,
I was able to resolve the issue based Rabbit suggestions to change it to a select query. It will sufficely do based on my needs. Thanks again to the both of you for your assistance!
Lev
lev9shun
Last Activity: Oct 28 '11, 11:31 PM
Joined: Oct 12 '11
Location:
-
Rabbit,
Perhaps I mis-understood your original question. But my thought was Medcond 101 was the only exception that I have. Which it still is in my opinion based on my orginal post.Leave a comment:
-
NeoPa - Unfortunately, the query came back as "Operation must use an updatable query.".Leave a comment:
-
Rabbit - In this example, it is the only exception.
NeoPa,
Here is my attempt in explaining the logic with the all possible outcomes:
If Patient A has medical conditions 100, 101, & 102, then then flag medical condition 101 as "Y", all else "N" in the 'Reported' field.
If Patient A only has Medical conditions 100 & 102, then flag medical both conditions as...Leave a comment:
-
NewPa,
I would like to create a query or vb script where the I can report on patients who has certain medical conditions. Just needing some assistance in getting started or pointed in the right directions on how to do so.
Current reporting table is:
ID Name MedCond Reported
1 Pat A 100
1 Pat A 101
1 Pat A 102
2 Pat B 100
2 Pat B 102
The outcome...Leave a comment:
-
How to flag records based on certain reporting conditions?
Hi all,
I have a reporting table that I use for my reports but would like to filter(flag) records based certain Medical conditions.
Example of reporting table:
ID Name MedCond Reported
1 Pat A 100 N
1 Pat A 101 Y
1 Pat A 102 N
2 Pat B 100 Y
2 Pat B 102 Y
Conditions examples are:
If patients have:
Medical Conditions
100...
No activity results to display
Leave a comment: