Calculating null values

[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?

 

[Guest]

Post your SQL.

 

[shannaj via AccessMonster.com]

Year Sales +/-: ([qryCustomerSales2007CT.Total Of Amount]-
[qryCustomerSales2006CT.Total Of Amount])

 

[Guest]

I meant for you to post your complete query SQL. What you posted does not
show how you used the NZ function.

Does your queries [qryCustomerSales2007CT.Total Of Amount] and
[qryCustomerSales2006CT.Total Of Amount] individually return values other
than zero?
--
KARL DEWEY
Build a little - Test a little

Year Sales +/-: ([qryCustomerSales2007CT.Total Of Amount]-
[qryCustomerSales2006CT.Total Of Amount])

Post your SQL.

 

[shannaj via AccessMonster.com]

Sorry, I figured it out. It took me looking at it in SQL to realize I did
not have it in my query. Thanks!

I meant for you to post your complete query SQL. What you posted does not
show how you used the NZ function.

Does your queries [qryCustomerSales2007CT.Total Of Amount] and
[qryCustomerSales2006CT.Total Of Amount] individually return values other
than zero?

Year Sales +/-: ([qryCustomerSales2007CT.Total Of Amount]-
[qryCustomerSales2006CT.Total Of Amount])

[quoted text clipped - 6 lines]