Prior record

[1234adam]

I am trying to write a query with several different fields. Some of the fields are linked to the current date. My problem is that one of the fields is an average of the prior week. I already have a query where the weekly averages are calculated. What I do not know how to do is to link Date() to the prior week in the average query.

Any suggestions?

I hope I am beinging clear enough.

 

[1234adam]

Or how do you refer to a cell one row above another. I can get this weeks average but I want last weeks, which is the prior record and just one cell above the current week in a query table.

 

[WayneRyan]

adam,

Hope this helps. It's for conditional formatting, but it does make use of
the value in a previous record.

http://www.access-programmers.co.uk/forums/showthread.php?t=68837&highlight=conditional+wayne


Wayne