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
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
fredg
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>
Y
yovation
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
F
fredg
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
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.
K
KARL DEWEY
I think you can use a query for your export and in it have a calculated field
like this to remove the sign --
Taxable: Abs([Taxable: Y/N])
--
KARL DEWEY
Build a little - Test a little
like this to remove the sign --
Taxable: Abs([Taxable: Y/N])
--
KARL DEWEY
Build a little - Test a little
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
Y
yovation
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
F
fredg
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
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.
Y
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.
OK. Thank you Fred and Karl for your help.
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.