falveym
03-20-2002, 08:22 AM
I have a table with Yes/No fields. When I run my query it calculates the yes/no fields up to give a percentage. It shows it as a negative number. How do you format it for a positive number.
|
View Full Version : Help on converting Yes/No field to positive number falveym 03-20-2002, 08:22 AM I have a table with Yes/No fields. When I run my query it calculates the yes/no fields up to give a percentage. It shows it as a negative number. How do you format it for a positive number. Shep 03-20-2002, 08:33 AM In your query's 'Field:' row... Abs([Name of your Field]) This gives the absolute value of the result of your query. Shep |