showing only certain records

[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

 

[pietlinden]

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

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.