P prabhus Registered User. Local time Yesterday, 23:22 Joined Mar 14, 2012 Messages 67 Aug 31, 2015 #1 Hi, My Query results are in Numver formar like 0 & -1, i have to update this data (using update query) to a table where the field is in Boolean format like Yes & No. How to do this? Please help
Hi, My Query results are in Numver formar like 0 & -1, i have to update this data (using update query) to a table where the field is in Boolean format like Yes & No. How to do this? Please help
arnelgp ..forever waiting... waiting for jellybean! Local time Today, 14:22 Joined May 7, 2009 Messages 20,243 Aug 31, 2015 #2 you already have a Boolean there .-1 is True. 0 is False. just do the normal update and it will not complain.
you already have a Boolean there .-1 is True. 0 is False. just do the normal update and it will not complain.
P prabhus Registered User. Local time Yesterday, 23:22 Joined Mar 14, 2012 Messages 67 Sep 1, 2015 #3 Thank you!!!
