I have a -1 and a 0 for values

I want to change them from the -1 to equal YES and the 0 to equal NO. Does
this need to be done from the table? If so, where do you make this happen?
OR, Does it need to be done in the make table query? If so, how?
--
Thomas

Use a Calculated Field in your query to transform the values:

YN: iif([YesNoField] = 0, "No","Yes")

--
Dave Hargis, Microsoft Access MVP


"T Miller" wrote:

I want to change them from the -1 to equal YES and the 0 to equal NO. Does
this need to be done from the table? If so, where do you make this happen?
OR, Does it need to be done in the make table query? If so, how?
--
Thomas

On Fri, 12 Oct 2007 10:28:01 -0700, T Miller wrote:

I want to change them from the -1 to equal YES and the 0 to equal NO. Does
this need to be done from the table? If so, where do you make this happen?
OR, Does it need to be done in the make table query? If so, how?

No, your table should store -1 or 0.

Wherever you need to display the value as "Yes" or "No", set the
Format property of that control to:
;"Yes","No";
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

On Fri, 12 Oct 2007 10:28:01 -0700, T Miller
wrote:

I want to change them from the -1 to equal YES and the 0 to equal NO. Does
this need to be done from the table? If so, where do you make this happen?
OR, Does it need to be done in the make table query? If so, how?

It should not be done in EITHER place. Tables are for data storage, not for
data presentation!

Yes *is* stored as -1, and No as 0. True and False are also synonyms, but the
actual storage is as a number. You don't need to care about that, though; if
you're going to display the value, you can use a Form (for onscreen use) or
Report (for printing), and set the format of the textbox bound to this field
appropriately.

John W. Vinson [MVP]

I have the same values, but I want a +1 for yes, and 0 for no. Since I want
these exported to Excel in the interim and eventually to figure out how to
make a chart in Access, I need the values reported as positive numbers for
calculations. Is that possible?

Also, for Yes, sometimes I want the value to be 6, or 7, or, 8 or whatever.
Yes having been assigned a weighted value for that particular input. Can I
do that? It need to be a positive value. How do I do that?
--
-Lost in Access


"T Miller" wrote:

I want to change them from the -1 to equal YES and the 0 to equal NO. Does
this need to be done from the table? If so, where do you make this happen?
OR, Does it need to be done in the make table query? If so, how?
--
Thomas