Previous Record In Query Calculation

I am trying to use the previous record to calculate production on the third shift in an Access 2000 query. Data entered at 7 AM is on a different day. Using Date()-1 does not work as I would like a history available. Can you help?