Numeric - Data

  • Thread starter Thread starter Bill
  • Start date Start date
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,
 
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
 
Back
Top