OfficialChad
New member
- Local time
- Yesterday, 20:50
- Joined
- Feb 13, 2020
- Messages
- 23
Hello, again great access world! hope all is well and yall are safe!
I've come to you guys about Conditional Formatting issue i have come to This is the rule I'm using and it currently checks all the data from the table "Checks" which causes every amount in the report to go red because it's using all the data, but I just want it to check the data from today in the checks table how would I go about adding some sort of filter? I tried filtering the table but it still picks up all the data. If anyone has an easier way of doing this also I'm all ears!
I've come to you guys about Conditional Formatting issue i have come to This is the rule I'm using and it currently checks all the data from the table "Checks" which causes every amount in the report to go red because it's using all the data, but I just want it to check the data from today in the checks table how would I go about adding some sort of filter? I tried filtering the table but it still picks up all the data. If anyone has an easier way of doing this also I'm all ears!
Code:
DCount("*","Checks","[C_Amount]=" & [C_Amount])>1