Numeric - Data

B

Bill

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

Randy Harris

Bill said:
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,
Click to expand...

An update query would do that:

Update MyTable
Set Code = Null
Where Code = 0

HTH,
Randy
 
Top