I have a query which when run gives the error "at most one record can be returned by this subquery" but when I run a report on the same query the report loads perfectly. This is the code for the query the query starts to load but then gives the error.
SELECT R1.Horse, R1.Racedate...