how do you do a query, which queries for a latest revision?

  • Thread starter Querying for a latest revision
  • Start date
Q

Querying for a latest revision

If you have a list of items and the revision number is updated eveytime you
make a new record for a new revision. How would you query to only see the
latest revision across all of the contracts.
 
S

Steve Schapel

You can use a Totals Query, Group By the Contract, and if you are using
the query designer, put Max in the Totals row in the Revision Number column.

Please post back with more details of your table structure, and what you
want to achieve, with examples, if you need any more specific help with
this.
 
Top