is it possible to condense these two queries into one?
select [Model],[Owner],[Date] from [Data]
where [Date] in(select [Model],max([Date] from [Data])
Something like this would work but if there was entries in multiple models on the same date that happens to be the max date for one model, it...