<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.45">
<TITLE>RE: [AccessD] Very interesting quirk in table design...</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>You sound like my wife. :-)</FONT>
<BR><FONT SIZE=2>Jim</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Gustav Brock [<A HREF="mailto:gustav@cactus.dk">mailto:gustav@cactus.dk</A>]</FONT>
<BR><FONT SIZE=2>Sent: Wednesday, May 14, 2003 10:49 AM</FONT>
<BR><FONT SIZE=2>To: accessd@databaseadvisors.com</FONT>
<BR><FONT SIZE=2>Subject: Re: [AccessD] Very interesting quirk in table design...</FONT>
</P>
<BR>
<P><FONT SIZE=2>Hi Charlotte</FONT>
</P>
<P><FONT SIZE=2>Would that be for Not Yes and Not No?</FONT>
</P>
<P><FONT SIZE=2>(sorry)</FONT>
</P>
<P><FONT SIZE=2>/gustav</FONT>
</P>
<BR>
<P><FONT SIZE=2>> Is the additional byte for the sign?</FONT>
</P>
<P><FONT SIZE=2>> Charlotte Foust</FONT>
</P>
<P><FONT SIZE=2>> -----Original Message-----</FONT>
<BR><FONT SIZE=2>> From: Henry Simpson [<A HREF="mailto:hsimpson88@hotmail.com">mailto:hsimpson88@hotmail.com</A>] </FONT>
<BR><FONT SIZE=2>> Sent: Wednesday, May 14, 2003 6:30 AM</FONT>
<BR><FONT SIZE=2>> To: accessd@databaseadvisors.com</FONT>
<BR><FONT SIZE=2>> Subject: Re: [AccessD] Very interesting quirk in table design...</FONT>
</P>
<BR>
<P><FONT SIZE=2>> Curious that in Access 97, and I'll assume subsequent versions as well,</FONT>
<BR><FONT SIZE=2>> a yes/no field stores 2 bytes for each entry. Using a numeric value</FONT>
<BR><FONT SIZE=2>> like a byte requires half the storage and gives you 8 states that</FONT>
<BR><FONT SIZE=2>> equate to 8 two state fields or 4 four state fields or whatever</FONT>
<BR><FONT SIZE=2>> other combination of 8 bits you devise, plus null. I've never</FONT>
<BR><FONT SIZE=2>> understood why the yes/no field requires two bytes and use bytes for</FONT>
<BR><FONT SIZE=2>> boolean fields for the increased flexibility.</FONT>
<BR><FONT SIZE=2>> Form logic doesn't seem to require any change if you simply use one byte</FONT>
<BR><FONT SIZE=2>> field for each field requiring a boolean display.</FONT>
</P>
<P><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>AccessD mailing list</FONT>
<BR><FONT SIZE=2>AccessD@databaseadvisors.com</FONT>
<BR><FONT SIZE=2><A HREF="http://databaseadvisors.com/mailman/listinfo/accessd" TARGET="_blank">http://databaseadvisors.com/mailman/listinfo/accessd</A></FONT>
<BR><FONT SIZE=2>Website: <A HREF="http://www.databaseadvisors.com" TARGET="_blank">http://www.databaseadvisors.com</A></FONT>
</P>
</BODY>
</HTML>