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.
