Showing previous data

[gpurger]

I have a report that has a sub and sub-sub report.

The database is based around documents, these documents have issues and ammendments and these have design updates.
1-many-many.

When viewing a Document and latest issue with updates (Form, sub, sub-sub)in a form I want the user to be able to display in a report the last update of the previous issue, i.e. issue -1.

Can anyone help me please?

Cheers Gordon

 

[WayneRyan]

Gordon,

About all I can think of is to use the TOP predicate in SQL to return the
TOP 2 records for your report.

Failing that, you might need a DLookUp (or a recordset) to retrieve the
previous values.

Wayne