Spreading data accross multiple records

W

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
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting Multiple Tables 1
Doughnut Chart linked with the slicer in the pivot table 0
Mail Merge skipping records/sending one at a time 0
Append query wont run because: 8
like a Pivot Table 0
one form to populate two tables 2
Find Window 2
Easy question about using group function on date. 3

Top