Autofill query

[Radhika]

I have a table called 'tbl_TEPRecords' with four fields of interest, 'ID#'
(primary field), 'DateOfVisit', 'VPInsertionDate' and 'VPRemovalDate'. I want
to create a query that autofills the 'VPInsertionDate' and 'VPRemovalDate'
from 'Date of Visit in the following way:

ID# DateOfVisit VPInsertionDate VPRemovalDate
111111 01/01/2001
111111 02/01/2001 01/01/2001 02/01/2001
111111 03/01/2001 02/01/2001 03/01/2001
444444 15/04/2007
444444 18/04/2007 15/04/2007 18/04/2007
444444 21/04/2007 18/04/2007 21/04/2007

How can I add an expression to the query that autofills the
'VPInsertionDate' with the previous 'DateOfVisit' and the 'RemovalDate with
the current 'DateOf Visit'

Thankyou,
Radhika