A Currency datatype will provide values into the trillions; a Double
Float will allow up to 14 decimal places of accuracy.
If you're using this value for an identifier - a part number, an
accont number, or the like - and will not be doing calculations with
it, use a Text datatype instead. This allows up to 255 digits <g>.
I never thought about the text data type, but you are right. The field I
need will be all numerical data, but I do not need to perform calculations
with it. I will make it text, and limit the characters to numerical ones.
Thank You.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
