So Access doesn't have a true Boolean datatype.... and neither does Filemaker (one uses a number field with values of non-zero or 0). <br>Which RDBMS <b>does</b> have a fair dinkum native Boolean datatype?<br><br>Maybe we're being led down a digital garden path! It might turn out that there is no RDBMS with a true Boolean datatype, which I'm afraid would lead to a rather stern letter to The Times.<br>
<br><div class="gmail_quote">On 4 April 2011 18:16, Timmer-Arends <span dir="ltr"><<a href="mailto:timmer@melbpc.org.au">timmer@melbpc.org.au</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div bgcolor="#ffffff">
<div><font face="Arial" size="2">Hello Maggie</font></div><div class="im">
<div><font face="Arial" size="2"></font> </div>
<div>2. Microslop Access does not have a Boolean datatype. It uses Yes/No as the
closest thing to that. </div>
<div> </div>
</div><div><font face="Arial" size="2">in fact 'yes/no' in ms access is Boolean. MS just
choose to display it as yes/no presumably in an effort to make it simpler for
the average user. You can also choose to display it as true/false or on/off.
</font></div>
<div><font face="Arial" size="2"></font> </div>
<div><font face="Arial" size="2">For example, you can use a "yes/no" field as a
condition in a calculated field in a query. <br> </font><font face="Arial" size="2">moreJunk: IIf([junk],"hello","goodbye")</font></div>
<div><font face="Arial" size="2">where [junk] is a field declared as yes/no; ie it's
boolean</font></div>
<div><font face="Arial" size="2"></font> </div>
<div><font face="Arial" size="2"></font> </div>
<div><font face="Arial" size="2">Regards</font></div>
<div><font face="Arial" size="2">Robert T-A</font></div>
<div><font face="Arial" size="2">Brighton SC</font></div></div>
<br>_______________________________________________<br>
<a href="http://www.edulists.com.au" target="_blank">http://www.edulists.com.au</a> - FAQ, resources, subscribe, unsubscribe<br>
IT Applications Mailing List kindly supported by<br>
<a href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html" target="_blank">http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</a> - Victorian Curriculum and Assessment Authority and<br>
<a href="http://www.vitta.org.au" target="_blank">http://www.vitta.org.au</a> - VITTA Victorian Information Technology Teachers Association Inc<br></blockquote></div><br><br clear="all"><br>-- <br>Mark Kelly<br>Manager of ICT, Reporting, IT Learning Area<br>
McKinnon Secondary College<br>McKinnon Rd McKinnon 3204, Victoria, Australia<br>Direct line / Voicemail: +613 8520 9085, Fax +613 9578 9253<br><a href="mailto:kel@mckinnonsc.vic.edu.au" target="_blank">kel@mckinnonsc.vic.edu.au</a><br>
VCE IT Lecture Notes: <a href="http://vceit.com" target="_blank">http://vceit.com</a><br>Moderator: IT Applications Edulist<br><br><font>All generalisations are false, except this one.</font><br><br>