Primary Key - Null Value

G

Guest

hi all,
I have a table containing a filed mixed a text and number, I want to use
this field as a primary key but it returns me null value "can not assign
primary key to the null value".

Can any one help on how to mix text and number and assign primary key to it
,thanks.
 
G

Guest

Hi,
for sure the field properties is changed to text, but when I try to assign
the primary key to this field it is not working and I get the below message"
the field contains the nullvalue and you can't assign the primary key" any
help thanks.
 
G

George Nicholson

That means that at least one of your existing records has a null value in
that field. Fix that condition and you will no longer get that error message
when you try to make it a primary field (but you might "graduate" to a
different error).

HTH,
 

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

Primary key cannot contain a null value. 2
create access table w/primary key 1
How can I tell if data entered is null? 2
MySQL "You tried to assign the Null value to a variable that is not a Variant data type. (Error 3162 1
validate import table primary key 4
Null value in primary key 1
Primary Key Help 3
adding primary key to table 2

Top