By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,826 Members | 2,443 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,826 IT Pros & Developers. It's quick & easy.

How do you write a conditional statement that depends only on part of a field?

P: 1
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 doing is averaging all of the quantities instead of just the ones under each material.

Is it possible to create a conditional statement where the average differs under each material subgroup?
Attached Images
File Type: jpg Picture1.jpg (8.8 KB, 94 views)
Apr 29 '10 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.