Access expression result

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Whenever I create an Access XP expression, if the expression is true, the
query returns "-1" as a result. I would much rather that this be "1". How
can I fix this?

Thanks.
 
I guess you could add a new column and use an "if" statement, but then that
column would not be updatable. -1 is the value used for true. You can
change the way it displays, but then you lose the ability to edit it.

If you display the query results in a form, you could use a checkbox
instead.

Rick B
 
Back
Top