Multiple Decimals

V

vanpar

I am wanting to enter my primary key values as numbers with multiple decimals
in them. ex. 1.11.112. Is there a way of doing this?
 
R

Rick B

Not using a NUMBER. NUMBERS don't have multiple decimals.

You can use a TEXT field to do this.
 
V

vanpar

I have tried setting the field as text but when i try to enter a new Id
number a message box come up saying "data type mismatch in criteria
expression".
Thanks!
 
R

Rick B

Sounds like you have some criteria that is still comparing the field as a
number. Using =, >, < or some similar item.
 
Top