I would try to get a value into the report's record source using a subquery. Generically:
SELECT *, (SELECT Count(*) FROM MyTable B WHERE B.LabValue BETWEEN A.LabValue - 4 and A.LabValue + 4) as MyCount
FROM MyTable A
Then use the MyCount column in your report to set the conditional formatting.
Duane Hookom, MVP
MS Access
From: MS_Access_Professionals@yahoogroups.com
To: MS_Access_Professionals@yahoogroups.com
Date: Thu, 1 Oct 2015 12:30:59 -0700
Subject: [MS_AccessPros] conditional formating
I created a report that gives me a list of labs that a person has had for the past six months. For instance their labs run 6,7,43,68,8, 92,92,2 and 93. What I am wondering is if there is a way using conditional formatting to be able to highlight any lab values that fall within a range of 4. Therefore in the example above, 6,7,8,92,92, and 93 would all have to be highlighted. Im pretty new at this, so any help you can give me would be appreciated. Thanks.
SELECT *, (SELECT Count(*) FROM MyTable B WHERE B.LabValue BETWEEN A.LabValue - 4 and A.LabValue + 4) as MyCount
FROM MyTable A
Then use the MyCount column in your report to set the conditional formatting.
Duane Hookom, MVP
MS Access
From: MS_Access_Professionals@yahoogroups.com
To: MS_Access_Professionals@yahoogroups.com
Date: Thu, 1 Oct 2015 12:30:59 -0700
Subject: [MS_AccessPros] conditional formating
I created a report that gives me a list of labs that a person has had for the past six months. For instance their labs run 6,7,43,68,8, 92,92,2 and 93. What I am wondering is if there is a way using conditional formatting to be able to highlight any lab values that fall within a range of 4. Therefore in the example above, 6,7,8,92,92, and 93 would all have to be highlighted. Im pretty new at this, so any help you can give me would be appreciated. Thanks.
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar