query help

C

Chad

I have a table that has the following Fields:

Last_Update (Yes/No)
ME_Date (Date/Time)

All of the ME_Dates are already loaded into the table
(just to clarify these dates are the end of accounting
months not actual months)

I would like to create a query that would set Last_Update
= Yes where the ME_Date is the one following the ME_Date
taht is already checked. I hope this example helps
clarify:

Before Query:

Last Update ME_Date
1/26/2003
X 2/23/2003
3/30/2003

After Query:

Last Update ME_Date
1/26/2003
2/23/2003
X 3/30/2003


Any help would be geatly appreciated,
Chad
 
Top