Y
yovation
Hello,
Is there any easy way to lose the (-). I would like Yes=1, No=0. (as
a check box)
thank you.
Yo
Is there any easy way to lose the (-). I would like Yes=1, No=0. (as
a check box)
thank you.
Yo
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.
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.