Spreading data accross multiple records

[William5271]

I have a date that I need to apply to all of the null feilds in a table.
There are over 3,000 and trying to select the nulls in a query and then
manually typeing in the same date on each one would be tedious. Is there
anyway to apply a date to all of the null feilds in a table? I just don't
want any of the records to have that feild blank.

your help would be much appreciated.

William

 

[Jerry Whittle]

UPDATE tblNulls SET tblNulls.Dates = #1/1/2008#
WHERE tblNulls.Dates Is Null;

Replace tblNulls.Dates with the actual table and field names. You would do
such an update query for each column/field in the table with the nulls one at
a time. If you have more than 3 or 4 such columns, there's a good chance that
your data is not properly normalized.