Maybe I should rephrase this in the form of a question :) I have a
table with workstations and timestamps. I'd like to select the record
with the most recent timestamp for each workstation. I know there is a
simple query to accomplish this but I'm having difficulty. Does anyone
have any
The default host table can possibly have multiple records for a given
workstation. Presumable the duplicate records are for historical
purposes, but only one is actually current. I don't really care why
there are duplicates but only need to a query to exclude the duplicate
records (leaving the