To clear certain fields of a table

[mercapto]

Hello, everyone.

I don't know if this must be a query or code.

When I first created my db, I used the "default value" for several fields. Some records don't use certain fields, so I'm planning to clear those fields to free memory space.

I believe I need to create a query with a "WHERE [Type] = n" condition. In this query I want to clear all the data in the rest of the fields (not in the type field, of course).



How would you do it??

[alansidman]

You should create an update query. Here is a link on how to do that.

http://www.databasedev.co.uk/update_query.html

[mercapto]

Thanks, alansidman, that was a very useful link.

I also had to check this one, indeed:

http://www.access-programmers.co.uk/...d.php?t=156892

Solved.