Multiple Decimals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Not using a NUMBER. NUMBERS don't have multiple decimals.

You can use a TEXT field to do this.
 
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!
 
Sounds like you have some criteria that is still comparing the field as a
number. Using =, >, < or some similar item.
 
You must log in or register to reply here.

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.

Ask a Question

Similar Threads

Make 1 field into 2 2
Primary Key & Unique Numbers with Decimals 6
Access stripping decimal places in query 1
Inserting decimal places 1
Same record/Primary key in multiple tables 0
Decimal Places 1
decimals 6
ACCESS TO EXCEL 1

Back
Top