Numeric - Data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill - 08 Dec 2005 00:29 GMT

Hi,

I create to make a table from the query. I have the column called "Code".
I open the table and notice that it has:

453
567
0
0
0
45789
123

How I force "0" to "blank after I make the table?

I need your help and your help would be much appreciated.

Thanks,

Reply to this Message

Randy Harris - 08 Dec 2005 00:54 GMT

> Hi,
>
[quoted text clipped - 14 lines]
>
> Thanks,

An update query would do that:

Update MyTable
Set Code = Null
Where Code = 0

HTH,
Randy

Reply to this Message

Bill - 09 Dec 2005 00:01 GMT

Thank you very much.. it works.

Is there a way to have automate for all the fields that has numeric only?
Instead of manually for 21 fields that has numeric.

Your help would be much appreciated.

Thanks,

***********************

> Hi,
>
[quoted text clipped - 14 lines]
>
> Thanks,

An update query would do that:

Update MyTable
Set Code = Null
Where Code = 0

HTH,
Randy

Reply to this Message