Thread: How to count negative numbers
View Single Post
  #2 (permalink)  
Old July 1st, 2009, 12:07 PM
SerranoG SerranoG is offline
Friend of Wrox
Points: 3,645, Level: 25
Points: 3,645, Level: 25 Points: 3,645, Level: 25 Points: 3,645, Level: 25
Activity: 2%
Activity: 2% Activity: 2% Activity: 2%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,114
Thanks: 2
Thanked 4 Times in 4 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default
You can use a DCount function on the record source... something like

=DCount("[Deviation]", "Table Name", "[Deviation] < 0")
__________________
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division
Reply With Quote