Charlotte Foust
cfoust at infostatsystems.com
Tue Mar 18 17:03:01 CST 2003
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/accessd Website: http://www.databaseadvisors.com