S
shannaj via AccessMonster.com
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?
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?