 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / March 2007Converting negative numbers into a zero
I am trying to convert values in the numeric field [HW] that are negative into zeros while keeping positive values unchanged. when I try the expression IIf([HW]<0,0,[HW]) as a crosstab query criteria the negative values all come out as 1, while the positive values remain unchanged. Does anyone know why I am getting 1 instead of 0 and what to do about it? update query: http://office.microsoft.com/en-us/access/HP051880881033.aspx make your search criteria "<0" update value "0" (omit quotation marks)  SignatureChris Hayes Still a beginner > I am trying to convert values in the numeric field [HW] that are negative > into zeros while keeping positive values unchanged. [quoted text clipped - 4 lines] > > Does anyone know why I am getting 1 instead of 0 and what to do about it? In design view of your crosstab, what do you have in the Group By row? Is it Count? That would make sense (counting 1 record.) SignatureAllen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. >I am trying to convert values in the numeric field [HW] that are negative > into zeros while keeping positive values unchanged. [quoted text clipped - 4 lines] > > Does anyone know why I am getting 1 instead of 0 and what to do about it? Thanks Allen I just had Group By left there. What should it be? > In design view of your crosstab, what do you have in the Group By row? > [quoted text clipped - 8 lines] > > > > Does anyone know why I am getting 1 instead of 0 and what to do about it? Switch the query to SQL View (View menu), and post the SQL statement. It might help us to see what's going on. SignatureAllen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. > Thanks Allen > [quoted text clipped - 15 lines] >> > Does anyone know why I am getting 1 instead of 0 and what to do about >> > it? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.