[AccessD] Very interesting quirk in table design...

Charlotte Foust cfoust at infostatsystems.com
Wed May 14 11:08:44 CDT 2003


:oP

That would be -1 as opposed to 1.

Charlotte Foust

-----Original Message-----
From: Gustav Brock [mailto:gustav at cactus.dk] 
Sent: Wednesday, May 14, 2003 7:49 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Very interesting quirk in table design...


Hi Charlotte

Would that be for Not Yes and Not No?

(sorry)

/gustav


> Is the additional byte for the sign?

> Charlotte Foust

> -----Original Message-----
> From: Henry Simpson [mailto:hsimpson88 at hotmail.com]
> Sent: Wednesday, May 14, 2003 6:30 AM
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] Very interesting quirk in table design...


> Curious that in Access 97, and I'll assume subsequent versions as
well,
> a yes/no field stores 2 bytes for each entry.  Using a numeric value
> like a byte requires half the storage and gives you 8 states that
> equate to 8 two state fields or 4 four state fields or whatever
> other combination of 8 bits you devise, plus null.  I've never
> understood why the yes/no field requires two bytes and use bytes for
> boolean fields for the increased flexibility.
> Form logic doesn't seem to require any change if you simply use one
byte
> field for each field requiring a boolean display.

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list