I need to find an event by the last time entered - it may have one or 10 items for the event, I only want to see the last one. It is not a datetime by default. so I have to concatenate to make it one. So I'm not sure on the where statement to find the last event entered by time performed.
dbo.Trip_Interventions.dateperformed + ' ' + dbo.Trip_Interventions.timeperformed AS [Intervention Time]
Thanks in advance