Access Query

[Mderry1]

I am trying to create a query that will populate blank or null cells.
I have a column of data that all cells do not contain a date.
I need to query the column and populate the blank cells with a current date.

After the blank cells are filled I will subtract it from a date received
column to obtain the numbers of day’s in-process for each open line of data.

Then I will average a weekly average query on the in-process items.

I’m having trouble getting the current date in the blanks cells

Does anyone have any suggestions?

 

[KARL DEWEY]

Use an Update query and update field with Date() with criteria Is Null.