Primary Key - Null Value

[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.

 

[Arvin Meyer [MVP]]

Here's 1 way:

http://www.datastrat.com/Download/AlphaNumeric2K.zip

 

[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.

 

[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,

 

[Arvin Meyer [MVP]]

A primary key cannot contain a null value. Any unique index can only contain
1 null value, since null does not equal anything (even another null value)
You must find the nulls and enter a unique value before you can create the
primary key.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com