Set Default Value - NA

H

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

Carl Rapson

hoachen said:
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
 

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

Top