when executing the sql statement to insert NULL: insert into table (column1, column2, column3) values(#one#, #two#, NULL) the inserted NULL needs no quotes. otherwise it is evaluated as the string NULL. regards, Alexander Sicular Director, Information Technology Neurological Institute of New York New York Presbyterian Hospital [EMAIL PROTECTED] 212.305.1318 | -----Original Message----- | From: Stuart Duncan [mailto:[EMAIL PROTECTED]] | Sent: Tuesday, April 04, 2000 7:02 PM | 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=list s/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.
