Access Query

  • Thread starter Thread starter Mderry1
  • Start date Start date
M

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?
 
Back
Top