showing only certain records

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

Guest

In the query i designed i have duplicate units but with unique work order
numbers, so they are not duplicate records, however i want to show only the
record with the highest WO #. What's the best way of going about this?

Thanks
 
In the query i designed i have duplicate units but with unique work order
numbers, so they are not duplicate records, however i want to show only the
record with the highest WO #. What's the best way of going about this?

Thanks
Click to expand...

use a totals query and use MAX on the WO#. Then you may have to join
that back to your original table to show the other fields, because you
can only have fields that are in the grouping(s) and grouping
functions (MIN, MAX etc) in your query.
 
Back
Top