Grabbing data from a previous record to use in my query

[kskelly]

I run a report daily which contains data from a query which uses data from a table which is populated by a form daily. Pretty straight forward so far. some data in today's record need to carry over to tomorrow's form. What is the easiest way?

[June7]

What is the data needed for?

Review http://allenbrowne.com/subquery-01.html#AnotherRecord

[kskelly]

The data is from a running totalizer on a machine in the plant. The readings are taken by three different people, eight hours apart. the morning readings are the final readings for the previous day and are used to calculate the running total for the day the next readings are taken at the beginning of the 2nd shift, eight hours later since there is no technician on the day shift to carry the readings forward.The day shift total is calculated using the end of the night shift readings and the beginning of the 2nd shift readings. The end of the night shift readings are the final readings on the previous day's record. I need to get those readings from the previous day to do the calculation.

[June7]

Forms are intended for input of raw data. Reports are intended for manipulation of data and doing calcs as you describe.

Did you try the query as demonstrated in the link?