Populating Null Records

H

Harmony

I have a query that displays the following records:

Status Product System_Date Count LoanAmt
Doc Draw 15 Yr. Fixed 10/23/2003 8 707350
Doc Draw 5-Year Call 10/23/2003 7 904450
Doc Draw Corres Pass 0 0
Doc Draw FHA Title 1 10/23/2003 1 5623
Doc Draw HELOC Open 10/23/2003 10 495400

The system_date of the third record is null. I would like
this field to have the same system_date as the other
records. Is there a way to populate this field with the
previous record?

Thanks,

Harmony
 

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

create record with a query in the same table 1
Count by Date 4
Populating null field in queries 8
Can You Figure Out What's Wrong W/ This Query 4
type mismatch error in macro in excel 0
Count issue continued from "text then date ascending count" 8
Update query 0
Need a query to return a value if out of range 4

Top