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?
 
Use an Update query and update field with Date() with criteria Is Null.
 
You must log in or register to reply here.

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

Excel Sumproduct 0
IIf statement in Access 2003 query 9
Maybe Update Query? 2
#error - Blank 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
How to populate a column in a row based on a value in another colu 3
Crosstab Query by Week with Dates as Headers 5
Interesting query requirement 1

Back
Top