Set Default Value - NA

[hoachen]

I read all the article that posted on this forum but could not find or make
it works.
Please help!!!

O.k, I have a client table name "CLIENT"with the column of "ClientID" and
"ClientName".
i created a query that pull the information of the client. And on the form I
would like to set the default value as NA and the client name from the table.

This column "ClientName" was just add to the DB and when i pull the previous
information which is no value and it give me "RUN-TIME ERROR '2427". I would
like all the previous data set to "NA" so that it will not give me an error
message.

Please direct me how can i achieve this.

Your help would be appreciated.

 

[Carl Rapson]

I read all the article that posted on this forum but could not find or make
it works.
Please help!!!

O.k, I have a client table name "CLIENT"with the column of "ClientID" and
"ClientName".
i created a query that pull the information of the client. And on the form
I
would like to set the default value as NA and the client name from the
table.

This column "ClientName" was just add to the DB and when i pull the
previous
information which is no value and it give me "RUN-TIME ERROR '2427". I
would
like all the previous data set to "NA" so that it will not give me an
error
message.

Please direct me how can i achieve this.

Your help would be appreciated.

Open up a new query in SQL view and enter something like the following:

UPDATE CLIENT SET ClientName="NA" WHERE ClientName IS NULL;

Run this query. This should change all empty ClientName entries to NA.

Carl Rapson