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=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.
