Obelik
05-25-2010, 06:36 PM
Hi,
I need help with this. I have a table with 6 distinct number variables (they are columns). I made a query to sum them accross row then return the absolute value (some variables have negative value). The results range from 0 to 5.
Now, I want Access to look at the results above and instead of returning 0 to 5, I want Access to return 0 for value </= 1 and 1 for value >1.
I don't know how to write the code telling Access to do that. I am learning how to write VBA code (first exposure to programing ever), but am stuck!
Can someone help?
Thanks!
I need help with this. I have a table with 6 distinct number variables (they are columns). I made a query to sum them accross row then return the absolute value (some variables have negative value). The results range from 0 to 5.
Now, I want Access to look at the results above and instead of returning 0 to 5, I want Access to return 0 for value </= 1 and 1 for value >1.
I don't know how to write the code telling Access to do that. I am learning how to write VBA code (first exposure to programing ever), but am stuck!
Can someone help?
Thanks!