Quickest way to display null values or 0 for multiple columns in table

[access_learner via AccessMonster.com]

I have over 20 columns of data that contains some null values or are blank.

I would like to know the most effective way to display the null values in all
the columns in a table.

I don't want to modify each column nz([column1],0).

After displaying the null value 0, I will be able to add the rows.

Thank you.

 

[Piet Linden]

I have over 20 columns of data that contains some null values or are blank.

I would like to know the most effective way to display the null values inall
the columns in a table.

I don't want to modify each column nz([column1],0).

After displaying the null value 0, I will be able to add the rows.

Thank you.

--

No quick way to do it, I don't think. About the easiest way to do it
would be to create a form, add a multi-select listbox, set the listbox
to be populated with the fields in the table, and then you could loop
through that and create the SQL and then use that to create a query in
code.

Why do you have so many null values in your tables?

 

[Allen Browne]

Create a form to display the data (Datasheet view if you want it to look
like a table.)

In form design view, select all the text boxes at once, and set their Format
property. The 4th value indicates what you want displayed for null, so use a
zero there.