If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Calculating null values
Post your SQL.
-- KARL DEWEY Build a little - Test a little "shannaj via AccessMonster.com" wrote: 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 |
#3
|
|||
|
|||
Calculating null values
Year Sales +/-: ([qryCustomerSales2007CT.Total Of Amount]-
[qryCustomerSales2006CT.Total Of Amount]) KARL DEWEY wrote: Post your SQL. 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 |
#4
|
|||
|
|||
Calculating null values
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 "shannaj via AccessMonster.com" wrote: Year Sales +/-: ([qryCustomerSales2007CT.Total Of Amount]- [qryCustomerSales2006CT.Total Of Amount]) KARL DEWEY wrote: Post your SQL. 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 |
#5
|
|||
|
|||
Calculating null values
Sorry, I figured it out. It took me looking at it in SQL to realize I did
not have it in my query. Thanks! KARL DEWEY wrote: 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] 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 |
Thread Tools | |
Display Modes | |
|
|