Set Default Value

Set Default Value - NA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hoachen - 04 May 2007 01:38 GMT

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.

Reply to this Message

Carl Rapson - 04 May 2007 16:21 GMT

>I read all the article that posted on this forum but could not find or make
> it works.
[quoted text clipped - 18 lines]
>
> 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

Reply to this Message