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=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
