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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use In() Expression as Query criteria with guts from Function 1
Access IIF and Instr function 1
expression with True of False showing up as -1 or 0 5
Viewing expressions in a listbox 4
Access Query problem 1
Query Returning Multiple Results 1
Field in Expression Displays Decimal Error (Access 2002) 8
Error in IIf Expression 5

Back
Top