|
Subject:
|
Visual Basic
|
|
Posted By:
|
monika.vasvani
|
Post Date:
|
5/13/2008 4:49:41 AM
|
Hi all
I have one problem.I have many tables in one database.I have one field as "VISIBLE" and datatype as "yes/no" in each table.
My reports are also having "Visible" field.I connect my report to access database,some report has answer as "Y" or "N" in visible field and some report has answer as "True" or "False"
how could be possible?
Pls reply me as early as possible
Thanks
monika
|
|
Reply By:
|
gbianchi
|
Reply Date:
|
5/13/2008 7:04:45 AM
|
Hi there. Maybe you are formatting the output to look like T/F or Y/N? access store the yes/no datatype as a boolean but you can use it like anything that's looks like boolean (even 0 and 1). In my case, my access values are usually SI/NO (yes/no in spanish). Representation of data is not the same as how the database store it.
HTH
Gonzalo
===========================================================
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
===========================================================
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
===========================================================
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles/Classics-Week-I-Hate-You.aspx
===========================================================
|
|
Reply By:
|
monika.vasvani
|
Reply Date:
|
5/14/2008 1:57:57 AM
|
Hi
Thanks for yr kind help.
I don't know how or where to set "Y" or "N" in my yes/no datatype field?my lookup is checkbox?
pls help me
how to do that?
thanks
monika
|
|
Reply By:
|
gbianchi
|
Reply Date:
|
5/14/2008 6:53:12 AM
|
Well, Y is True and N is False. Why do you mean that you don't know where to set them? the only thing that you have to be carefull about is that checkbox use values 0/1 and in the database will be stored like 0/-1 (or was the other way, anyway one of your values is the opposite you need).
HTH
Gonzalo
===========================================================
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
===========================================================
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
===========================================================
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles/Classics-Week-I-Hate-You.aspx
===========================================================
|
