I am trying to create a database that list materials and their quantities, and highlights quantities that come up outside a certain percentage range against the average. I have tried the following conditional formatting:
Condition 1: [quantity]>Avg([quantity])*1.5;
Condition 2: [quantity]<Avg([quantity])*0.5
However, there are a lot of different materials that differ in quantity, and what the report is...
cljordan
Last Activity: May 3 '10, 12:34 PM
Joined: Apr 29 '10
Location:
-
cljordan started a topic How do you write a conditional statement that depends only on part of a field?in AccessHow do you write a conditional statement that depends only on part of a field?
No activity results to display