change yes or true to positive number

F

Frank Bavis

I'm working for a small charity and have a database using check box for
yes/no to monitor the work we do for the funders many years ago I had an
expression think it was on office 79 to chage the value of yes to a posotive
number which enabled me to create reports from the queeries. It was a long
expression and I got it from microsoft but have lost it. Can anyone help or
suggest another method which may be easier as I'm not a techie. At work I am
using access 2003 but have 2007 at home.
Thanks
Frank
 
M

Marshall Barton

Frank Bavis said:
I'm working for a small charity and have a database using check box for
yes/no to monitor the work we do for the funders many years ago I had an
expression think it was on office 79 to chage the value of yes to a posotive
number which enabled me to create reports from the queeries. It was a long
expression and I got it from microsoft but have lost it. Can anyone help or
suggest another method which may be easier as I'm not a techie. At work I am
using access 2003 but have 2007 at home.
Click to expand...


A True value is -1 so you can use -field or Abs(field) to
convert it to +1.
 
Top