Hello,
Is there any easy way to lose the (-). I would like Yes=1, No=0. (as
a check box)
thank you.
Yo
No. In Access a Yes/No check box field is either -1 or 0.
This should not be causing you any difficulty. If you think it is
causing difficulty, then I would suggest you give us more information
so someone can help.
Of course you could create your own Number datatype field and give it
any values you wish, i.e. 12 = Yes and 45 = No. But it's just more
work and really isn't necessary.<g>
No. In Access a Yes/No check box field is either -1 or 0.
This should not be causing you any difficulty. If you think it is
causing difficulty, then I would suggest you give us more information
so someone can help.
Of course you could create your own Number datatype field and give it
any values you wish, i.e. 12 = Yes and 45 = No. But it's just more
work and really isn't necessary.<g>
More information: My database has products in it. I have a field
that is labeled [Taxable: Y/N]. The problem comes in when I export
the data from access and import it into my online ecommerce store.
The store doesn't like the -1. It uses 0 for non taxable, and 1 for
taxable.
Thank you
yo
yovation said:No. In Access a Yes/No check box field is either -1 or 0.
This should not be causing you any difficulty. If you think it is
causing difficulty, then I would suggest you give us more information
so someone can help.
Of course you could create your own Number datatype field and give it
any values you wish, i.e. 12 = Yes and 45 = No. But it's just more
work and really isn't necessary.<g>
More information: My database has products in it. I have a field
that is labeled [Taxable: Y/N]. The problem comes in when I export
the data from access and import it into my online ecommerce store.
The store doesn't like the -1. It uses 0 for non taxable, and 1 for
taxable.
Thank you
yo
More information: My database has products in it. I have a field
that is labeled [Taxable: Y/N]. The problem comes in when I export
the data from access and import it into my online ecommerce store.
The store doesn't like the -1. It uses 0 for non taxable, and 1 for
taxable.Thank you
yo
The field is labeled "Taxable: Y/N" or is NAMED "Taxable: Y/N"? There
is a difference.
Create a query with all of the fields in the table, except [Taxable:
Y/N].
Then add a calculated field to the query:
NewTaxable:[Taxable: Y/N] * -1
Export this query instead of the table.
No is still 0. Yes is now +1.
On Wed, 17 Sep 2008 13:42:31 -0700 (PDT), yovation wrote:
Hello,Is there any easy way to lose the (-). I would like Yes=1, No=0. (as
a check box)thank you.
YoNo. In Access a Yes/No check box field is either -1 or 0.
This should not be causing you any difficulty. If you think it is
causing difficulty, then I would suggest you give us more information
so someone can help.Of course you could create your own Number datatype field and give it
any values you wish, i.e. 12 = Yes and 45 = No. But it's just more
work and really isn't necessary.<g>More information: My database has products in it. I have a field
that is labeled [Taxable: Y/N]. The problem comes in when I export
the data from access and import it into my online ecommerce store.
The store doesn't like the -1. It uses 0 for non taxable, and 1 for
taxable.Thank you
yo
The field is labeled "Taxable: Y/N" or is NAMED "Taxable: Y/N"? There
is a difference.
Create a query with all of the fields in the table, except [Taxable:
Y/N].
Then add a calculated field to the query:
NewTaxable:[Taxable: Y/N] * -1
Export this query instead of the table.
No is still 0. Yes is now +1.
I don't know the difference between Labeled and Named. This
particular Field Name is: [Taxable].
Maybe I asked the wrong question all together. Here is what I am
working on. I am building a form, and there is a Field Named
[Taxable]. There Field has 2 options available: 0=No, 1=Yes.
How would you recommend implementing this field on a form?
Thank you.
Yovation
42:31 -0700 (PDT), yovation wrote:
Hello,
Is there any easy way to lose the (-). I would like Yes=1, No=0. (as
a check box)
thank you.
Yo
No. In Access a Yes/No check box field is either -1 or 0.
This should not be causing you any difficulty. If you think it is
causing difficulty, then I would suggest you give us more information
so someone can help.
Of course you could create your own Number datatype field and give it
any values you wish, i.e. 12 = Yes and 45 = No. But it's just more
work and really isn't necessary.<g>
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
More information: My database has products in it. I have a field
that is labeled [Taxable: Y/N]. The problem comes in when I export
the data from access and import it into my online ecommerce store.
The store doesn't like the -1. It uses 0 for non taxable, and 1 for
taxable.
Thank you
yo
The field is labeled "Taxable: Y/N" or is NAMED "Taxable: Y/N"? There
is a difference.
Create a query with all of the fields in the table, except [Taxable:
Y/N].
Then add a calculated field to the query:
NewTaxable:[Taxable: Y/N] * -1
Export this query instead of the table.
No is still 0. Yes is now +1.I don't know the difference between Labeled and Named. This
particular Field Name is: [Taxable].Maybe I asked the wrong question all together. Here is what I am
working on. I am building a form, and there is a Field Named
[Taxable]. There Field has 2 options available: 0=No, 1=Yes.How would you recommend implementing this field on a form?Thank you.
Yovation
My previous reply of multiplying the Field value by -1 will work, as
will Karl Dewey's.
Just change the field name to whatever your actual field name is.