Prev: 学习 M本0602班 郑建姣
Next: Change Form/Report Query Based on User Selection
From: Jerry Anderson on 7 Dec 2009 11:23
I have a query that includes a Yes/No field. When it displays the results in
a list box, I want it to display Yes or No, rather that 0 or 1. I'm sure this
must be easy, but...
From: KARL DEWEY on 7 Dec 2009 11:42
You can format the field of use an IIF statement like this --
My_Field: IIF([SomeField] = -1, "Yes", "No")

--
Build a little, test a little.


"Jerry Anderson" wrote:

> I have a query that includes a Yes/No field. When it displays the results in
> a list box, I want it to display Yes or No, rather that 0 or 1. I'm sure this
> must be easy, but...
 | 
Pages: 1
Prev: 学习 M本0602班 郑建姣
Next: Change Form/Report Query Based on User Selection