how to set values of all the data in a table to spaces or zeros

[punky]

I want to set the values of all the fields (records) in the table to spaces or 0 accordingly. Can I do this with a single line of code or do I have to address each field in the table separately to update it's contents. I am hoping there is an "initialize" piece of code to do this quickly since some tables have so many fields.

 

[MisterC]

Why not just use a delete query to delete all the records in the table?

 

[punky]

I need to maintain the records in the table, so I do not want to delete them.

 

[MisterC]

If you set all fields to 0 or null, then you have effectively deleted the records. What is it you are trying to keep?

 

[punky]

I have a report with several sub reports. These reports need the tables with at least one record in them so the sub reports will reflect 0 in necessary fields. If no tables exist for the sub report, that sub report doesn't show up on the main report. I don't want the report to be half there. If there are no numbers for a particular department, then zeros must be displayed on the report.

If you have a better method, please let me know.