Re: No Nulls or Decimals for Numbers?
At 04:01 PM 04/04/2000 Stuart wrote: 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. Access will accept nulls in integer or long integer field as long you have no properties set like indexing or validation that require a value, and as long as this is not the primary key field for table. Judith Campbell -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: No Nulls or Decimals for Numbers?
Hi Stuart, First, if you wish to use nulls in Access then you need to set the field up as Required:No If the field is set to currency and you're trying to put in integers then that should work. If you're trying to stuff the field with an amount using the DollarFormat that wont work. You can use the CF function Replace to rid yourself of the dollar sign and the commas, the stuff it into the field. 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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: No Nulls or Decimals for Numbers?
Check your table definitions in Access.. Access defaults "Allow Zero Length" to "No" for the columns you add. Change this to "Yes" for each column and hopefully that'll fix it. -Original Message- From: Stuart Duncan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 04, 2000 6: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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.