[AccessD] Default Value On Numerics

Andy Lacey andy at minstersystems.co.uk
Wed Mar 19 01:29:01 CST 2003


Well I wasn't, cos I've never used MAKE TABLE. Nevertheless thanks for
the definitive answer Charlotte.

Andy Lacey
http://www.minstersystems.co.uk



> -----Original Message-----
> From: accessd-admin at databaseadvisors.com 
> [mailto:accessd-admin at databaseadvisors.com] On Behalf Of 
> Charlotte Foust
> Sent: 18 March 2003 22:59
> To: accessd at databaseadvisors.com
> Subject: RE: [AccessD] Default Value On Numerics
> 
> 
> I think you may be thinking of what happens in a make table 
> query.  In 97, 2000 and XP, all numeric fields added to a 
> table automatically default to 0.  If you don't want a zero 
> default, you can remove the value.  But if you create a table 
> using a make table query, the default doesn't get set.
> 
> Charlotte Foust
> 
> -----Original Message-----
> From: Andy Lacey [mailto:andy at minstersystems.co.uk] 
> Sent: Tuesday, March 18, 2003 2:34 PM
> To: accessd at databaseadvisors.com
> Subject: [AccessD] Default Value On Numerics
> 
> 
> A question that we on the BEU project would like an answer to.
> 
> We all find that if we add a numeric value to a table the 
> Default Value is automatically set to 0. And yet....a couple 
> of us have a sneaking feeling we've seen Access leave the 
> Default as null. Was this an earlier version, or are we 
> hallucinating? 
> 
> Andy Lacey
> http://www.minstersystems.co.uk
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
> 




More information about the AccessD mailing list