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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Use a Group By statement associated with the Max () function.

S. L.

"Querying for a latest revision" <Querying for a latest
(e-mail address removed)> wrote in message
news:[email protected]...
 
Back
Top