database

  • Thread starter Thread starter Ber
  • Start date Start date
B

Ber

How can i enter a ISBN number into a database without it telling me that it
is invalid
 
Hi Ber,

Enter the ISBN Number as a text data type and be sure you set the length
long enough.

Steve
(e-mail address removed)
 
ISBN numbers are TEXT not numbers. Change the datatype of the field in your
table to text.
 
you must ensure that the field is designated as a Text data type since some
ISBNs use characters and not all numbers
 
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

Relationships & Primary Key in a Book Inventory Database 3
leading zeros 3
Extracting characters from a field with Access 2003 3
ISBN data type 10
Experience with SRU/SRW/CQL? 7
Hitting the limits with large table in Excel containing 1 millionrecords. What is the best option fo 2
Record-Locking remains open after closing 0
delete duplicates 5

Back
Top