Fill null fields from last non-null record - No update query pleas

[mattsmom]

I need to fill in blank fields with the date from the previous record, but I
don’t want to use an update query. End users are inputting the date via a
form and I need this information to be available immediately without having
to wait for me to run an update. Help is greatly appreciated!
Example:
Batch StrucID StrucType InspType Initial ProjMgr
14 72S022 Cantilever Routine 02/22/08 03/17/08
14 72S025 Cable Interim
14 72S027 Mast Initial
14 72S030 Traffic Special

 

[Jeff Boyce]

How are you determining "previous"? Access stores data in tables as it sees
fit. You can control the order in which it is displayed, so you'll need to
provide the sort criterion. The example you posted appears to be physically
organized, but what determines the proper order?

There's no reason you couldn't create an update query that you then had the
user run by simply clicking a button.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[mattsmom]

Thank you so much for your response. I’ve done some simple update queries in
2003, but we have upgraded to 2007 and I’m not sure how to fill a null field
with data from the previous record.

I’m don’t know if you need this, but here’s how my database works….I input
records via a form that only I use (frmDataInput), this updates the table
(tblMaster). When reports are physically sent to the other 5 employees they
open a different form (frmTrackingSystem) using a Batch # parameter and input
the date they complete their review in their respective control. (Each
employee has a different control: Initial, ProjMgr, ProjMgrRtn, MMS and BSE.)
The form FrmTrackingSystem has a record source of QryMaster. All of the
records in the query are sorted by Batch then Structure Number. A macro in
the property field Before Update of each of the controls goes to the first
record in the query to input the date they enter. At the bottom of
FrmTracking a control labeled Print, closes the form opens a print dialog to
input the # of copies needed, and opens a report. I’m trying to get the date
each employee enters on all of the records in the batch, instead of just the
first, so the report can be printed immediately. Thanks again for any help!