Fields will only accept nulls if the column definition allows it.
Integer fields will only accept integer values, for decimal values, you need
to use float, double, currency or numeric(X,X) datatypes.
Michael J. Sheldon
Internet Applications Developer
Phone: 480.699.1084
http://www.desertraven.com/
PGP Key Available on Request
-----Original Message-----
From: Stuart Duncan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 04, 2000 16:02
To: [EMAIL PROTECTED]
Subject: No Nulls or Decimals for Numbers?
Hey all, this is probably a bit of a beginner question... but where else
should I ask right?
I have a database (in Access) that I'm trying to put a bunch of prices
into. And when I set the fields as integers, long integers,etc it says that
they can't be null and I don't want to put a 0 in there. Also they can't be
made into decimals either.
The Dollar format just doesn't work, because it automatically puts in those
dollar signs and throws everything off. Almost everything other than text
wouldn't allow a null value.
I need them as number values, so I can do the math with them.
In the insert query though, if the number is blank, it doesn't put anything
there, and I get to commas together and an error.
Any help would be appreciated!
Stuart.
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
