Report only specific amounts

  • Thread starter Thread starter Microsoft
  • Start date Start date
M

Microsoft

I have a text box on my report that counts the number of text items that are
common in a field called DCODES. I use =count([Dcodes]). this works fine.

I want to only show the results that are over a certain amount such as
greater than 4.
How can I do this?
Help?
 
Use a control source like:
=Sum( Abs([DCodes]>4) )
This assumes DCodes is the field that contains the value you are checking.
 
Back
Top