View Single Post
  #1  
Old August 7th, 2007, 10:33 PM posted to microsoft.public.access.reports
shannaj via AccessMonster.com
external usenet poster
 
Posts: 35
Default Calculating null values

I have a database that compares our customer sales for 2006 and 2007. I
created a text box to calculate the difference in the 2006 and 2007 sales. I
have used the NZ function to eliminate my null values to get the 0 value for
the values for 2006 and 2007. When the value for sales for 2006 or 2007
ends up being 0, it does not calculate the difference. Can someone please
help?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200708/1